Tuesday, March 2, 2021
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

    - Advertisement -
    dbametrix
    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

    Recent Comments