Cursor_Anonymous_Procedure1.htm |
Objective :
|
This example reemphasize the importance of PL/SQL as a reporting tool which embeds a SQL statement in a anonymous procedural block, execute special routine or function, and then fetch the data row by row while displaying custom results. |
Scott: emp table:
|
Cursor PL/SQL Script:
|
SQL Developer: Quotes "anonymous block completed", where a SQL* Plus quotes as a "Procedure Block" |
|