Re: argh, SQL sucks....stupid quirk...
Date: 1995/06/24
Message-ID: <3shvi6$ket_at_ixnews3.ix.netcom.com>#1/1
In <3sbnbo$bem_at_cville-srv.wam.umd.edu> beefstew_at_wam.umd.edu (T.J.
Klevinsky) writes:
>
>I can't believe the error I just got with SQL*PLUS. I have 2 selects
>one after the other in a script...basically 2 seperate queries, but I
>want them to print out one after the ohter. It wasn't working because
>SQL.PNO would reset after each query (page 1, page2, page 1, etc) so
>I set embedded on. NOW, it has a btitle on a page by itself between
>the queries. The numbers number correctly but the btitle screws up.
>
>ANy suggestions?
Check out the UNION operator. It may do what you want by combining the two query results into one.
Another option is to create a temporary table and copy the results of your two queries into it. Then run your report from the temp table.
>Or should I just use some plastic explosives?
Tends to result in a lot of fragmentation. :)
--Received on Sat Jun 24 1995 - 00:00:00 CEST
><> Chuck Hamilton <><
><> chuckh_at_ix.netcom.com <><