Oracle’s PL/SQL questions

Topics to learn in pl/sql?

Posted by silpa on Dec 07 2006 | Comment now »

# 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

[CREATE [OR REPLACE] PACKAGE package_name {IS | AS}

END package name;

BODY

[CREATE [OR REPLACE] PACKAGE BODY package_name {IS | AS}

BEGIN

END package name;