Using SQL *Plus to Create Report and Manage Pl/SQL code
SQL*Plus is an environment in which you can
Execute SQL statements to retrieve, modify, add, and remove data from database
tables.
Format, perform calculations on, store, and print query results in the form of
reports.
Issue SQL statements to create, alter, and remove database tables.
Create anonymous blocks, subprograms, database triggers using procedural
language extension, PL/SQL.
SQL*Plus has a variety of commands you need to use to execute subprograms, pass
values in and out of PL/SQL blocks, and debug your code.
SQL*Plus commands may be divided into the following main categories....