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!

Difference between LATERAL JOIN and CROSS APPLY JOIN in Oracle 12c

Harinath ArasuNov 5 2015 — edited Nov 15 2015

Hi All,

I'm trying to explored new functions available in Oracle 12c but got stuck in identifying the differences between the 2 new joins introduced in Oracle 12C for inline view implementation.

I referred to the Oracle documentation, still unable to figure out any difference between the results produced by these 2 functions. Its always the same

https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#BABDADCJ

Kindly assist to understand if there are any differences in the resultset if these functions are used in the same dataset?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2015

Added on Nov 5 2015

7 comments

9,639 views