Hi Friend,
Do you know there is a limitation of sub-query in Oracle? If you don’t know, then keep in mind the following limitation.
There is a limitation of Oracle for Subqueries. You can use unlimited sub-queries in the FROM clause of the main query. You can use a maximum 255 sub-queries in the WHERE clause of Oracle. This limitation is the same in Oracle 10g and Oracle 11g. There is no change of this sub-query limitation in both Oracle versions.
Beware of using more sub-queries in WHERE clause of the main query.
Thanks and regards,
Remote DBA Team
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.
Hi,
Yes its known by me , Its the first question I ask while back then on 9i when Sub Query Concept was introduce to the class.
But great to have such tips back.for the developers..
Thanks..