PL/SQL - Basic Syntax

PL/SQL - Basic Syntax - Comments - Program Units - First PLSQL program

Basic Syntax of a PL/SQL program is:


DECLARE
<declarations section>
BEGIN
<executable section>
EXCEPTION
<exception handling section>
END;

My 'First PL/SQL' Program:


DECLARE
v_message varchar2(20):= 'My first PLSQL program!';
BEGIN
dbms_output.put_line(v_message);
END;
/

Complete Tutorial

*/

No comments:

Post a Comment