Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: select with set operators and brackets
Hi all!
I would like to issue the following SELECT in PL/SQL:
(SELECT 1 FROM dual MINUS
SELECT 2 FROM dual)
UNION
(SELECT 3 FROM dual MINUS
SELECT 4 FROM dual)
How I can do it? It works in SQL but (SELECT 1 INTO x ... ) doesn't work in
PL/SQL.
Thanks a lot,
--
G o m b o s B e r t a l a n
system engineer, Oracle developer
mailto:bgombos_at_freemail.c3.hu
Received on Fri Nov 19 1999 - 09:47:23 CST