Topics to learn in pl/sql?
Posted by silpa on Dec 07 2006
# Overview of SQL
* SQL Statements
o Data Manipulation Language Statements
o Data Definition Language Statements
o Transaction Control Statements
o Session Control Statements
o System Control Statements
o Embedded SQL Statements
* Cursors
o Scrollable Cursors
* Shared SQL
* Parsing
* SQL Processing
o SQL Statement Execution
o DML Statement Processing
o DDL Statement Processing
o Control of Transactions
* Overview of the Optimizer
o Execution Plans
# Overview of Procedural Languages
* Overview of PL/SQL
o How PL/SQL Runs
o Language Constructs for PL/SQL
o PL/SQL Program Units
o Stored Procedures and Functions
o PL/SQL Packages
o PL/SQL Collections and Records
o PL/SQL Server Pages
Leave a Comment