RE: Displaying Title When No Data Returned

Wayne,

Try:

   ttitle 'My Title'
   col dummy noprint
   select dummy from dual;

   <your query here...>

HTH, Yosi

> -----Original Message-----
> From: Wayne S Bellefeuille [mailto:wbellefe_at_allina.com]
> Sent: Wednesday, September 13, 2000 11:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Displaying Title When No Data Returned
>
>
> I am using the SQLPLUS TTITLE statement to display a number
> of standard audit
> reports. The problem is, when there are no rows returned,
> the report title is
> not displaying.
>
> Does anyone have a technique for making sure that a SQLPLUS
> report title is
> always displayed, even when there is no data?
>
> Wayne
>
> --
> Author: Wayne S Bellefeuill
> INET: wbellefe_at_allina.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 13 2000 - 11:10:52 CDT