Xref: alice comp.databases.oracle.server:74823
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeed.berkeley.edu!news-stock.gip.net!news-dc.gip.net!news.gsl.net!gip.net!news.elender.hu!not-for-mail
From: Gombos Bertalan <bgombos@freemail.c3.hu>
Newsgroups: comp.databases.oracle.server
Subject: Q: select with set operators and brackets
Date: Fri, 19 Nov 1999 16:47:23 +0100
Organization: Elender Rt.
Lines: 17
Message-ID: <3835710B.D78FBE67@freemail.c3.hu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: newsgate.elender.hu 943026494 2029 194.143.246.74 (19 Nov 1999 15:48:14 GMT)
X-Complaints-To: usenet@newsgate.elender.hu
NNTP-Posting-Date: 19 Nov 1999 15:48:14 GMT
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: hu,en

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@freemail.c3.hu