A Different Approach to Subqueries With Oracle 12c

In this article, I’ll speak about improvements that were made by Oracle 12c and SQL, such as the phrases LATERALCROSS APPLY, and OUTER APPLY. I hope this will be a helpful article in terms of awareness.

When writing queries in database versions before Oracle 12c, we weren’t able to use correlated subqueries in the FROM section of our query. With Oracle 12c, the basis for our uses and needs of this sort has been addressed.

What feeling does this article give you?

#hashtags to follow:

SQL [+]    LATERAL [+]    CROSS APPLY [+]    OUTER APPLY [+]   

More #news: