Wednesday, August 5, 2020
dbametrix
More
    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 -
    dbametrix

    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

    0
    Previous articleHow to tune disk IO
    Next articleWhich is best Database

    1 COMMENT

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

      Thanks..

    Comments are closed.

    - Advertisment -
    dbametrix

    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