My 1st pl/sql program

basic block of pl/sql
declare
bigin
exception
end


1st pl/sql program

set serveroutput on
begin
dbms_output.put_line ('hello world') ;
end;
/


2nd pl/sql program

set serveroutput on
declare
x number;
bonus number;
begin
select sal into x from emp where empno=7369;
bonus := x*0.10 ;
dbms_output.put_line (bonus) ;
end;
/


types of blocks in pl/sql

anonymous
function
procedure