RE: Displaying Title When No Data Returned

Hi
Try:

COLUMN DUMMY NOPRINT TTITLE 'Whatever...'
SET FEEDBACK OFF
SELECT DUMMY FROM DUAL;
SET FEEDBACK ON
TTITLE OFF Now your select statement.

You will always have the title without the feedback from SELECT DUMMY FROM DUAL; -
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: Wayne S Bellefeuille [SMTP:wbellefe_at_allina.com]
> Sent: Wednesday, September 13, 2000 9: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:11:02 CDT