Re: Q:Report w SQL Plus

Ralf,

Unrelated to your question, make sure you have this:

HH24:MI:SS

not this:

HH24:MM:SS

...when formatting the time.

'MI' denotes minutes, not 'MM'. (I've make this mistake many times...)

-- 
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Ralf Bender <Ralf.Bender_at_wolnet.de> wrote in article
<35ae5c61.0_at_dns.wolnet.de>...


> Hello *.*,

> I'm writing a report like this:

> --------------------------SNIP

 ON-----------------------------------------


> set echo off

> set linesize 80

> set pagesize 60

> 

> column today new_value today_date

> select to_char(sysdate,'HH24:MM:SS DD-Mon-YYYY') today

> from dual;

> 

> ttitle left today_date  right 'Seite : ' format 999 sql.pno skip 2 -

>  center '- Gebuchte, NICHT archivierte Belege -' skip 1

> 

> 

> 

> btitle skip 1 '*** D:\ORANT\SOFTMATI\LL0222.SQL ***'

> 

> spool d:\orant\softmati\ll0222.txt

> select belegnummer from LL0222notinscan order by 1;

> spool off

> host print d:\orant\softmati\ll0222.txt

> exit

> --------------------------SNIP

 OFF-----------------------------------------


> If the select found any rows, the report looks ok.

> But if there no rows, it only write that there no rows found. How can I

 get


> the ttitle and bttitle, when no rows found.

> 

> Such report print automatically in the evening, and if there more reports

> with no rows I don't know which report it is.

> 

> 

> bye ,

> ralf

> mailto:Ralf.Bender_at_wolnet.de

> 

> 

> 

>