Structure of pl-sql program

Prev Tutorial Next Tutorial

Structure of pl-sql program

pl-sql program is very easy to write and execute, Here i will show you in very simple way. pl-sql program contains mainly four section, they are given below;

  • Declare section
  • Begin section
  • Exception section
  • End section


declare				-------- 1
declaration variable;
begin				-------- 2
exception			-------- 3
exception handling statements
end;				-------- 4
  • Declare section: In this section user declare all the variables, cursor declaration etc.
  • Begin section: In this section, you need to declare all the executable statements, logical statements etc.
  • Exception section: In this section you need to write all the exception handling statements, which is used to convert system defined error message into user friendly error message.
  • End section: In this section represent end of the pl-sql program or block.


dbms_output.put_line("Hello word");

Prev Tutorial Next Tutorial

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain,, @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: WhatsApp no. 8882538826

Yahoo Advertisements