Sunday, 18 November 2007

Remarks in Script with Ttitle and Btitle

The TTITLE (top title) and BTITLE (bottom title) commands have this syntax:

TTITLE option text OFF/ON

where option refers to the placement of the title:

1. COLUMN n (start in some column, n)
2. SKIP m (skip m blank lines)
3. TAB x (tab x positions)
4. LEFT/CENTER/RIGHT (default is LEFT)

The same holds for BTITLE.

In addition, page numbers may be added with the extension:

option text format 999 sql.pno

SQL*Plus

SQL*Plus is a tool for interfacing with the oracle database
You can use it to

1. Execute SQL and PL/SQL in the database
2. Update data in your database
3. Perform queries on your data
4. Format the result sets of those queries into reports
5. Create, edit, retrieve, and execute SQL scripts
6. Administer the database