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 get number from 0 to 99

Yash ParasharJun 14 2022 — edited Jun 15 2022

I already tried this program

SELECT LEVEL - 1
FROM DUAL
CONNECT BY LEVEL <= 10000000

on "https://livesql.oracle.com/apex/f?p=590:1:15240902803423::LEVEL1:RP::#" but it prints only 0 to 49. screen shot attached.
Note : I also download that below mentioned csv file, but it has the same data as shown on website.
oraclelive_sample Also I need a little help to print table of 2 in "2 x 1 = "' format. with using LOOP/IF/CASE or any of these.

This post has been answered by L. Fernigrini on Jun 14 2022

Jump to Answer

Added on Jun 14 2022

#11g, #developer, #pl-sql, #plsql

10 comments

2,867 views

1 mention