OraFAQ Forum: SQL & PL/SQL » OUTER UNION CORR

Home » SQL & PL/SQL » SQL & PL/SQL » OUTER UNION CORR

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

OUTER UNION CORR [message #219948]

Fri, 16 February 2007 20:15

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,

Report message to a moderator

Re: OUTER UNION CORR [message #219950 is a reply to message #219948]

Fri, 16 February 2007 23:07

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Describe it.

Report message to a moderator

Re: OUTER UNION CORR [message #219957 is a reply to message #219950]

Sat, 17 February 2007 00:09

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.

Report message to a moderator

Re: OUTER UNION CORR [message #219978 is a reply to message #219957]

Sat, 17 February 2007 02:37

Frank
Messages: 7901
Registered: March 2000

Senior Member

No. Oracle does not have a similar construction. Oracle's union constructions only work on ordinal position.

Report message to a moderator

Re: OUTER UNION CORR [message #219997 is a reply to message #219978]

Sat, 17 February 2007 07:40

dpong
Messages: 73
Registered: January 2007

Member

Thanks for your confirmation.

Report message to a moderator

Previous Topic:	NO ROWS SELECTED when using BIND VARIABLE
Next Topic:	don't get any rows when given 'like' condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 11 02:50:45 CST 2026