Monthly Archives: March 2014

Scalar Subquery Unnesting in Oracle 12c.

A Scalar Subquery is a subquery that appear in select clause and that will return only one records having one column.For record return more then one, it is bound be to give error. select co1, (select max(col1) from table2 where … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , | 3 Comments