oracle tips & tricks

Oracle Tips & Tricks

 
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

Labels:

posted by popo @ 16:57   0 comments
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

Labels:

posted by popo @ 16:55   0 comments
 
Search

Google
Previous Post
Category
Blogrush
Blogroll
Legal
Archives
Template by
Free Blogger templates