Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Q: select with set operators and brackets

Q: select with set operators and brackets

From: Gombos Bertalan <bgombos_at_freemail.c3.hu>
Date: Fri, 19 Nov 1999 16:47:23 +0100
Message-ID: <3835710B.D78FBE67@freemail.c3.hu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US