MATERI

1
MATERI
Procedures
Functions
Packages
Database Triggers
2
PL/SQL

• Introduction

3
About PL/SQL

• PL/SQL is the procedural extension to SQL with
  design features of programming langguages
• DML and query statements of SQL are included
  within procedural units of code

4
PL/SQL Environment
PL/SQL Block
PL/SQL Block
Procedural Statement Executor
SQL statement executor
5
Benefits of PL/SQL

• Integration

Application
Oracle Server
Shared library
6
Benefits of PL/SQL

• Improved Performance

SQL
Other DBMSs
Application
SQL
SQL
SQL
SQL IF...THEN SQL ELSE SQL END IF SQL
Oracle with PL/SQL
Application
7
Benefits of PL/SQL

• Modularize program development

DECLARE
BEGIN
EXCEPTION
END
8
Benefits of PL/SQL

• It is portable.
• You can declare identifiers.
• You can program with procedural language control
  structures.
• It can handle errors.

9
Benefits of Subprograms

• Easy maintenance
• Improved data security and integrity
• Improved Performance
• Improved code clarity

10
Invoking Subprograms
LOG_EXECUTION procedure
PROCEDURE leave_emp
Developer Portal Discoverer
Another Proc. or Functions
iSQLPlus