OraFAQ Forum: SQL & PL/SQL » Print 1 .. 100 numbers using Dual table in SQL statement

Home » SQL & PL/SQL » SQL & PL/SQL » Print 1 .. 100 numbers using Dual table in SQL statement (Any Oracle Database version)

Fri, 19 February 2016 04:56

9390512774
Messages: 103
Registered: January 2011
Location: hyd

Senior Member

Dear Experts,

I want to print 1..100 numbers using SELECT statement with dual table.

ex:

SELECT ..... FROM Dual.....;
output
------
1
2
3
4
5
6
7
..
..
..
100

Fri, 19 February 2016 05:59

doganaym
Messages: 1
Registered: February 2015
Location: Turkey

Junior Member

simply you can use connect by:

SELECT ROWNUM r FROM dual CONNECT BY ROWNUM <= 100;

[Updated on: Fri, 19 February 2016 06:02] by Moderator

Fri, 19 February 2016 06:03

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

See row generator.

Thu, 03 March 2016 06:11

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No feedback as usual.

[Updated on: Thu, 03 March 2016 06:12]

Previous Topic:	v$session
Next Topic:	Response in JSON format

Goto Forum:

]

Current Time: Thu May 09 02:21:01 CDT 2024