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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Book OCP Oracle Certified Professional Java SE 17 Developer Practice Tests: Exam 1Z0-829