Sunday, January 14, 2018

Oracle PLSQL Tutorials for Beginners Introduction To PLSQL













DECLARE
 /*   this is multi line <declarations section> */
 -- this is a single line comment
BEGIN
 /*  <executable command(s)> */
EXCEPTION
 /*  <exception handling> */

END;
/

BEGIN
NULL;
END;
/

SET SERVEROUTPUT OFF;
SET SERVEROUTPUT ON;


BEGIN
dbms_output.put_line('This Is First PLSQL Program');
END;
/


DECLARE
   V_MyVar  varchar2(100):= 'Hello, World! This is First PLSQL Program';
   V_Number number:=55;
BEGIN
   dbms_output.put_line(V_Myvar);
   dbms_output.put_line(V_Number);
END;
/


/******************************************************************************
                          PL/SQL Program Objects -  Execution Units
******************************************************************************/

A PL/SQL unit is any one of the following Objects.......

   => PL/SQL Default block
   => Procedure - Object
   => Function - Object
   => Package - Object
   => Package body - Object
   => Triggers - Object
   => Type - Object
   => Type body -Object

No comments:

Post a Comment