Chapter – I

PL/SQL

(Informatics Practices)

PL/SQL = Procedural Language extensions to SQL
An Oracle-specific language combining features of:

• modern, block-structured programming language
• database interaction via SQL

Designed to overcome declarative SQL's inability to specify control aspects of DB interaction.

Used to add procedural capabilities to Oracle tools.

PL/SQL is implemented via a PL/SQL engine (cf. JVM)

• which can be embedded in clients (e.g. Forms, SQL*Plus)
• which is also usually available in the Oracle server ..............