Skip to Main Content

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!

LEFT JOIN Vs OUTER APPLY

SaubhikNov 15 2022

Today, I am somewhat dumb, I tried by actually firing the query but somehow not became confident.
Query 1:
select * from table_1 left outer join table_2 ON `1=1;
Query 2:
select * from table_1 OUTER APPLY table_2;
Is this two same? Can I write Query 1 in some other way (without using 1=1) ?

This post has been answered by Frank Kulash on Nov 15 2022
Jump to Answer
Comments
Post Details
Added on Nov 15 2022
5 comments
3,151 views