Results 1 to 4 of 4

Thread: infinit query..

  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Talking Unanswered: infinit query..

    can anybody send me a select query where the result is infinity.

    for example if im counting natural numbers ..it never ends...

    thanx for all ur answers...

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    You can make an infinite loop with PL/SQL but not with the SQL as SELECT statement has a limit of Total number of the rows(or Cartesian Product) into the table(s).

    It canbe make posibble if you perform cartisian product on 8-10 tables where almost all tables have thousands of rows.

    SELECT *
    FROM a, b, c, d, e, f, g, h, i, j, k;

    Where all tables in the above statement has thousands of rows. Total objects in the universe is 10 to the power of 80, and this cartesian product may end up to this number which computer can not calculate.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Nov 2003
    Posts
    87
    thanx .

    But i need a single select query.


  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    It is not possible.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •