Sql*plus outputs

[sammybee]

Hi All,

I've set up a script that runs 3 seperate select statements. At the begining of the script there is a title using Ttitle left 'sadljkfdlk'.

The title only appears above the 2nd set of results - any ideas why this is?

also is it possible that I could have a different title for each of the select statements?

Many thanks in advance

Sam

 

[LKBrwnDBA]

Yes you can have diff titles, one for each select, this should work:

Ttitle left 'sadljkfdlk - Select 1'
select ...from table1;
Ttitle ce 'sadljkfdlk - Select 2'
select ...from table2;
Ttitle ri 'sadljkfdlk - Select 3'
select ...from table3;

Example:

SQL>Ttitle left 'sadljkfdlk - Select 1'
SQL>select 'First', sysdate from DUAL table1;

sadljkfdlk - Select 1
'FIRS SYSDATE
----- -----------
First 11-JAN-2005

SQL>Ttitle ce 'sadljkfdlk - Select 2'
SQL>select 'Second', sysdate from DUAL table2;

                              sadljkfdlk - Select 2
'SECON SYSDATE
------ -----------
Second 11-JAN-2005

SQL>Ttitle ri 'sadljkfdlk - Select 3'
SQL>select 'Third', sysdate from DUAL table3;

                                                           sadljkfdlk - Select 3
'THIR SYSDATE
----- -----------
Third 11-JAN-2005

SQL>

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb