Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order by in Union

SmidrebJan 28 2012 — edited Jan 28 2012
Hi All,

If we don't specify the order by clause in UNION/UNION ALL then what is the default order of the data

Select Stmnt1
UNION
select Stmnt2



Select Stmnt1
UNION ALL
select Stmnt2

I am using version 10G AND 11G

Thanks
This post has been answered by J2EE_Life on Jan 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2012
Added on Jan 28 2012
4 comments
2,552 views