OraFAQ Forum: SQL & PL/SQL » How to print vertical numbers

Home » SQL & PL/SQL » SQL & PL/SQL » How to print vertical numbers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to print vertical numbers [message #616538]

Wed, 18 June 2014 02:06

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Guys,

How to print vertical numbers in used only sql query:

Output:
1
2
3
4
.
.
.
100

Report message to a moderator

Re: How to print vertical numbers [message #616540 is a reply to message #616538]

Wed, 18 June 2014 02:22

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

SQL> SELECT LEVEL FROM dual CONNECT BY LEVEL <=10;
     LEVEL
----------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10
10 rows selected

Report message to a moderator

Re: How to print vertical numbers [message #616541 is a reply to message #616540]

Wed, 18 June 2014 02:24

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

This might be useful for you, have a look at different techniques Row Generator

Report message to a moderator

Re: How to print vertical numbers [message #616543 is a reply to message #616541]

Wed, 18 June 2014 02:32

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Thank you so much Lalit for giving ans. and good link. Actually I am looking such type of helping link so that I can learn more, if you have some more helping link then Please share with us.

Report message to a moderator

Re: How to print vertical numbers [message #616560 is a reply to message #616543]

Wed, 18 June 2014 05:26

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

Senior Member
Account Moderator

Almost all the topics here and in other forums are helpful to learn.
You can also have a look at our SQL puzzles

Report message to a moderator

Previous Topic:	create separate record for each column
Next Topic:	DBMS_JOB: Numerous jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 15 23:50:24 CDT 2024