Introductions Of PL/SQL

PL/SQL

• It is a programming language which is used to define our own logics.
• It is used execute block of statements at a time and increase the performance.
• It supports variables and conditional statements and loops.
• It supports object oriented programming and supports composite data types.
• It supports handle the error handling mechanism.

•  Block
• It is one of the area which is used to write a programming logic.
• This block is have 3 sections.
• Declaration Section
• Executable Section
• Exception Section

1.    Declaration Section

§  It is one of the section which is used declare variables, cursors and exceptions and so on.

§  It is optional section.

2.    Executable Section

§  It is one of the section which is used to write a program coding.

§  It is mandatory section.

3.    Exception Section

§  It is one of the section which is used to handle the errors at runtime.

§  It is optional section.