The following query should return 100 rows but only returns 1 row. This used to work OK in Toad 9.1. It returns 100 rows for a 10g database but does NOT return the rows for a 9i database. It looks like it's not running the 'Connect by level < 101' line.
select case when mod(rownum,3) = 0 AND mod(rownum,5) = 0 THEN
to_char(rownum || ' FizzBuzz')
when mod(rownum,3) = 0 THEN
to_char(rownum || ' Buzz')
when mod(rownum,5) = 0 THEN
to_char(rownum || ' Fizz')
Else
to_char(rownum)
END
from dual
connect by level < 101
Should return:
COLUMN_1
--------------
1
2
3 Buzz
4
5 Fizz
6 Buzz
7
8
9 Buzz
10 Fizz
...
100 Fizz
Actually returns:
COLUMN_1
-------------------------------------------------
1
WORKAROUND:
none
STATUS:
Waiting for fix in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center