PL/SQL
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database.
Technical Information
- Doing SQL from PL/SQL: Best and Worst Practices
- How to write SQL injection-proof PL/SQL
- PL/SQL Enhancements in Oracle Database 11g
- The utlirplscope.sql script for 11.1.0.6
- Conditional Compilation in Oracle Database 10g Release 2 (10.2)
- New PL/SQL Features in Oracle Database 10g Release 1 (10.1.0)
- FAQ: PL/SQL Native Compilation (NCOMP) in Oracle Database 10 g Release
Click here for Technical Info for previous releases
Sample Code
Click here to see Oracle PL/SQL sample code.
Articles and Columns
Technical advice based on the real-world experiences of PL/SQL users
- Best Practice PL/SQL: Q&A with Steven Feuerstein and Bryn Llewellyn
- Picking Your Packages: Key Benefits and Underlying Behaviors
- Writing Better SQL Using Regular Expressions
- More PL/SQL Technical Articles...
PL/SQL Books
- Oracle Database 11g PL/SQL Programming by Michael McLaughlin
- Oracle Database 11g PL/SQL Programming Workbook by Michael McLaughlin
- Oracle PL/SQL Programming by Steve Feuerstein and Bill Pribyl
- Mastering Oracle PL/SQL: Practical Solutions by Connor McDonald (Sample Chapter PDF)
- Oracle Database 10g PL/SQL Programming by Scott Urman, Ron Hardman, Michael McLaughlin
- Oracle Database 10g PL/SQL 101 by Christopher Allen
- Mastering Oracle PL/SQL: Practical Solutions by Connor McDonald
- Oracle PL/SQL by Example, Third Edition by Benjamin Rosenzweig, Elena Silvestrova
- Oracle PL/SQL Language Pocket Reference, 4rd Edition by Steven Feuerstein, Bill Pribyl, Chip Dawes
- Oracle PL/SQL Best Practices, 2nd Edition by Steven Feuerstein
Printer View