Overview of PLSQL

 

Simple anonymous block

begin

dbms_output.put_line('my first anonyms block');

end;

 

Anonymous block with multiple output line

begin

dbms_output.put_line('this the first line');

dbms_output.put_line('this is the second line');

end;

Anonymous block with DECLARE section (no variables)

declare

begin

dbms_output.put_line('hello world');

end;

Anonymous block with a variable declared and printed 

declare

v number;

begin

v:=5;

dbms_output.put_line('hello world');

dbms_output.put_line(v);

end;