Re: hopefully easy SQL question

From: DI Karl Heinz Hörmann <kh.hoermann_at_penta.at>
Date: Tue, 25 Jan 2000 04:43:10 +0100
Message-ID: <86j5qi$25f$1@newsmaster01.magnet.at>

Bryan wrote in <0237dd28.64b998b7_at_usw-ex0104-028.remarq.com>...
>Dear all,
>
>I am tring to write some SQLplus to produce a listing. Whereas
>prodicing the listing itself is easy, I am having a problem, since what
>I want to do is conditionally produce one of two listings, dependant on
>the outcome of a query.

>i.e. if resilt of a query is that a value is present then listing 1 is
>produced, if it is null, thn another listing is produced.

depending upon the complexity of the listings and the associated queries there might be several solutions -
is the only problem the different formatting ? or is it different queries ? does the control-variable take part in the query ??

if its just formatting of the same query, try to use the control-variable in 'decode'-Terms of the query -
with different queries you could select an appropriate 'run q(var)' statement into a spool-file and execute that one ...

regards Received on Mon Jan 24 2000 - 21:43:10 CST