Home » SQL & PL/SQL » SQL & PL/SQL » OUTER UNION CORR
OUTER UNION CORR [message #219948] Fri, 16 February 2007 20:15 Go to next message
dpong
Messages: 73
Registered: January 2007
Member
Hi,

It seemed to me Oracle doesn't have OUTER UNION CORR, which is available in Proc SQL (SAS). Does anyone know if there's some sort of solution to do OUTER UNION CORR in Oracle SQL ?

Thanks,
Re: OUTER UNION CORR [message #219950 is a reply to message #219948] Fri, 16 February 2007 23:07 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Describe it.
Re: OUTER UNION CORR [message #219957 is a reply to message #219950] Sat, 17 February 2007 00:09 Go to previous messageGo to next message
dpong
Messages: 73
Registered: January 2007
Member
http://v8doc.sas.com/sashtml/proc/zueryexp.htm

I think if you have used SAS, this will be equivalent to SAS's set statement or proc append.

Re: OUTER UNION CORR [message #219978 is a reply to message #219957] Sat, 17 February 2007 02:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
No. Oracle does not have a similar construction. Oracle's union constructions only work on ordinal position.
Re: OUTER UNION CORR [message #219997 is a reply to message #219978] Sat, 17 February 2007 07:40 Go to previous message
dpong
Messages: 73
Registered: January 2007
Member
Thanks for your confirmation.
Previous Topic: NO ROWS SELECTED when using BIND VARIABLE
Next Topic: don't get any rows when given 'like' condition
Goto Forum:
  


Current Time: Fri Dec 09 21:44:55 CST 2016

Total time taken to generate the page: 0.08147 seconds