RE: SQL help

[Fink, Dan]

Title: RE: SQL help

Rick,

    Is this in SQL*Plus? If so, use the COLUMN command to populate the column headings with the information you want. You can populate a variable with SYSDATE and use that in the column heading.

 

Dan

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL help

Not tested .... but

select sysdate, 'test1','test2'
from dual
where exists ( your union clause)
union
your_union_clause

Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL help

Hi DBAs,

I have a query something like

SELECT sysdate,'txt1','txt2'
FROM dual
UNION
SELECT date1,txtfield1,txtfield2
FROM t1,t2,...,tn
WHERE
....... ;

The output would be one header record from the first select then the data
from the second select.
If there are no records selected in second select the header record is
still selected.  If there are no
records in second select I do not want header record selected.  How can I
suppress it? I do not want to apply the where
clause in 2nd select to the first because of the complexity.

Thanks
Rick

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).