Do you know there is a limitation of sub-query in Oracle? If you don’t know then keep in mind following limitation.

There is a limitation of Oracle for Subqueries. You can use unlimited sub-queries in FROM clause of main query. You can use maximum 255 sub-queries in WHERE clause of Oracle. This limitation is same in Oracle 10g and Oracle 11g. There is no change of this sub-query limitation in both Oracle versions.

Get Oracle DBA Job Quickly

About US

This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.