RE : Displaying Title When No Data Returned

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Wed, 13 Sep 2000 18:26:51 +0200
Message-Id: <10618.116852@fatcity.com>

Wayne,

This works :

ttitle sample title
column dummy noprint
select * from dual;
select * from user_tables
where table_name = 'XXXX'
/

-- 
Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:    +44  (0) 7050-696-449 
  Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------


> 

> 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

Received on Wed Sep 13 2000 - 11:26:51 CDT