Friday, October 30, 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

    - 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

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments