Tag: cross apply

Little enhancements are always nice

Before LATERAL and CROSS APPLY were added (exposed to us) in 12c, a common technique to do correlated joins was using the TABLE/MULTISET technique. For example, we might have had a couple of tables: SQL> create table t as 2 select object_type, min(created) min_dte,…