Tag Archives: Sql transformation

Query Transformation playing with syntactically wrong SQL.

In Oracle whenever any SQL didn’t adhere syntax defined, it is bound to give some error. Any SQL is processed after syntax check is validated. In current blog will try to walk you through some SQL, that seems incorrect but … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , | Leave a comment

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