PL/SQL is an language that was designed for processing of SQL commands.
PL/SQL stands for Procedural Language extension of SQL.
Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable.
PL/SQL is a block structured language, which means program is in logical blocks of code.
Structure
| DECLARE <declarations section> BEGIN <executable command(s)> EXCEPTION <exception handling> END; |
Example
| DECLARE msg varchar2(50):= 'PL/SQL Example'; BEGIN dbms_output.put_line(msg); END ; / |
Links
