PLSQL study material
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 3. Declaration Section § It is one of the section which is used declare variables, cursors and exceptions and so on. § It is optional section. 4. Executable Section § It is one of the section which is used to write a program coding. § It is mandatory section. 5. Exception Section § It is one of the section which is used to handl...