14-08-2012, 12:28 PM
PL/SQL
PL.ppt (Size: 131.5 KB / Downloads: 41)
Declaration Section
Contains all variables , constants, records which are to manipulate data in execution section
Executable Section
Contains SQL statements to manipulate data in the database.
Exception Handling
Specifies the actions to perform when errors & abnormal conditions arise
Advantages of PL/SQL
Support for SQL
Block Structure
Better performance
Error handling
Modularity
Portability
Integration
Dbms_output.put_line()
The procedure Dbms_output.put_line will produce
The output on the screen.
It accepts only one argument.
Hence the different variables are cocatenated with
Double pipe( |) symbol.
Eg.
Dbms_output.put_line(empno|ename);