Let us discuss about Running PL/SQL Blocks in SQL*PLUS

• In PL/SQL mode semicolon (;) can be used multiple times in single program
• Editing of instruction same as in the SQL statements
• End; appears as the termination of the program
• / can initiate execution of the program

Comment Statements

• Block of comments are delimited with /* */
• /* < comment that spans more than one line of code > */
• Single comment line starts with 2 hyphens
– comment on a single line

Displaying PL/SQL Output in SQL*Plus

• Normally PL/SQL is used with other Oracle utilities such as forms or reports
• PL/SQL in SQL*Plus
• Command to activate memory buffer in SQL*Plus to enable output from PL/SQL programs:
SQL > SET SERVEROUTPUT ON