OraFAQ Forum: SQL & PL/SQL » Any idea why INTERSECT ALL is not working here

Home » SQL & PL/SQL » SQL & PL/SQL » Any idea why INTERSECT ALL is not working here (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Any idea why INTERSECT ALL is not working here [message #329792]

Thu, 26 June 2008 09:55

renu4dwh
Messages: 24
Registered: April 2008
Location: Pune

Junior Member

When i am trying to fire the query which is using INTERSECT ALL operator i am getting the following error:

ERROR at line 1:
ORA-00928: missing SELECT keyword

And here is the simple query :

 SELECT *
FROM   T10
INTERSECT ALL
SELECT *
FROM   T11;

Here is the Version Information :

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE    9.2.0.1.0       Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

Report message to a moderator

Re: Any idea why INTERSECT ALL is not working here [message #329793 is a reply to message #329792]

Thu, 26 June 2008 09:57

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

Hi,
I think there's no "intersect all". Check this.

http://www.ss64.com/ora/union.html

Regards,
Rhani

Report message to a moderator

Re: Any idea why INTERSECT ALL is not working here [message #329807 is a reply to message #329792]

Thu, 26 June 2008 10:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL Reference
Chapter 4 Operators
Section Set Operators

Regards
Michel

Report message to a moderator

Previous Topic:	I need an Example on this
Next Topic:	how to use custom datatype in SQL ???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 18:19:52 CST 2025