Home » SQL & PL/SQL » SQL & PL/SQL » Any idea why INTERSECT ALL is not working here (9i)
Any idea why INTERSECT ALL is not working here [message #329792] Thu, 26 June 2008 09:55 Go to next message
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
Re: Any idea why INTERSECT ALL is not working here [message #329793 is a reply to message #329792] Thu, 26 June 2008 09:57 Go to previous messageGo to next message
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
Re: Any idea why INTERSECT ALL is not working here [message #329807 is a reply to message #329792] Thu, 26 June 2008 10:48 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Chapter 4 Operators
Section Set Operators

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


Current Time: Thu Dec 08 12:20:53 CST 2016

Total time taken to generate the page: 0.09440 seconds