Oracle Data integrator 11G & 12c Tutorials,

Sunday, January 14, 2018

Oracle PLSQL Tutorials For Beginners 2, PLSQL Variables & SubTypes Tu...

/*****************************************************************************
   PLSQL DATA TYPES
   => Char
   => Varchar2
   => Date
   => NUMBER ( Integer )
   => Boolean True or Flase
*****************************************************************************/

DECLARE
V_Char char(100):='This is Char';
V_Varchar varchar2(100):='This is Varchar Data Type';
V_Number Number(10):=55555;
V_Date    DATE:=SYSDATE;
V_Boolean BOOLEAN:=true;
BEGIN
dbms_output.put_line('Welcome Char Variable : ::: '||V_Char );
dbms_output.put_line('Welcome Varchar Variable : ::: '||V_Varchar );
dbms_output.put_line('Welcome Number Variable : ::: '||V_Number );
dbms_output.put_line('Welcome Date Variable : ::: '||V_DATE );
IF V_Boolean THEN
dbms_output.put_line( 'This is Boolean Variable ::: TRUE');
else
dbms_output.put_line( 'This is Boolean Variable ::: FALSE');
END IF;
END;
/

/*****************************************************************************
   PLSQL SUB TYPES
*****************************************************************************/

DECLARE
   SUBTYPE name IS char(20);
   SUBTYPE address IS varchar2(100);
   SUBTYPE phone IS NUMBER(10);
   V_MyName name;
   V_My_Address address;
   V_My_Phone phone;
BEGIN
   V_MyName := 'Test Char... ';
   V_My_Address := 'Welcome to the PLSQL SubTypes..';
   V_My_Phone :=999999999;
   dbms_output.put_line('Sub Type Char : ::: ' || V_MyName );
   dbms_output.put_line('Sub Type Varchar2 : ::: '|| V_My_Address);
   dbms_output.put_line('Sub Type Varchar2 : ::: '|| V_My_Phone);
END;
/

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