Wednesday, August 5, 2020
    Home Oracle Troubleshooting Sub Query limitation in Oracle

    Sub Query limitation in Oracle

    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.

    - Advertisement -

    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

    Previous articleHow to tune disk IO
    Next articleWhich is best Database


    1. 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..


    Comments are closed.

    - Advertisment -

    Most Popular

    What was new in Oracle 12c

    Blog post explains in detail Oracle 12c new features for Developers including in-memory and Advanced Index Compression.

    The Life of DBAs is Changing

    Article explains how The Life of DBAs is Changing in Self-Managing Oracle Database. An detail introduction of Oracle Autonomous Database Cloud

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Recent Comments