Oracle 9i PL/SQL Programming

  • 7h 28m
  • Scott Urman
  • Oracle Press
  • 2002

Create robust PL/SQL programs to access an Oracle database from a variety of environments. Officially authorized by Oracle Corporation, Oracle 9i PL/SQL Programming explains the major features of the language and the variances in PL/SQL between different database versions. You'll learn to develop, test, and debug your PL/SQL applications and work in different development environments. You'll also get specifics on SQL and PL/SQL usage, error handling, collections, subprograms and packages, and advanced features.

  • Work in various PL/SQL development and execution environments
  • Get details on PL/SQL syntax, variables, datatypes, expressions, operators, and control structures
  • Use cursors for multirow queries and explicit control of SQL statement processing
  • Write PL/SQL programs that detect and react intelligently to runtime errors
  • Take advantage of multi level collection capabilities of Oracle 9i
  • Develop DML, instead-of, and system triggers to enforce complex data constraints
  • Exploit advanced PL/SQL features, including external routines, native dynamic SQL, bulk binds, and object types

About the Author

Scott Urman is a Senior Member of Technical Staff in the Diagnostics and Defect Resolution (DDR) team in Oracle's Server Technology division. He currently focuses on the internals of JSP and Oracle Text, and has worked with JDBC, Pl/SQL, and OCI. Prior to joining DDR, he was a Senior Analyst in the Languages division of Oracle Worldwide Technical Support, focusing on all of Oracle's language tools. He has been with Oracle since 1989. He is also the best-selling author of Oracle 8i Advanced PL/SQL Programming and Oracle8 PL/SQL Programming.

In this Book

  • Introduction to PL/SQL
  • Development and Execution Environments
  • PL/SQL Basics
  • SQL within PL/SQL
  • Built-in SQL Functions
  • Cursors
  • Error Handling
  • Collections
  • Creating Procedures, Functions, and Packages
  • Using Procedures, Functions, and Packages
  • Database Triggers
  • Advanced Features
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Oracle on Docker: Running Oracle Databases in Linux Containers
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Book Pro Oracle SQL Development: Best Practices for Writing Advanced Queries, Second Edition