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
Sunday, 18 November 2007
Remarks in Script with Ttitle and Btitle
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
Subscribe to:
Posts (Atom)