SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query to print from 1 to 100

435794Jan 7 2005 — edited Jan 11 2005

Hi

Recently I was asked this question. How to print numbers from 1 to 100 using a select statement? No table is available. Also if a table is given with one column which contains a few random values between 1 and 100 how to print those values between 1 and 100 that do not exist in the table?

Regards
Venkat

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2005

Added on Jan 7 2005

3 comments

10,334 views