OraFAQ Forum: SQL & PL/SQL » How to display sequence of numbers using select statment

Home » SQL & PL/SQL » SQL & PL/SQL » How to display sequence of numbers using select statment

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

How to display sequence of numbers using select statment [message #8977]

Wed, 08 October 2003 13:31

pavan
Messages: 10
Registered: October 2001

Junior Member

Hi,
I need to display 0 to 20 numbers in the form LOV. how can i write the select statment to display the numbers in lov.

bye

Report message to a moderator

Re: How to display sequence of numbers using select statment [message #8981 is a reply to message #8977]

Wed, 08 October 2003 13:42

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql>select rownum rn from all_objects where rownum <= 5;  -- adjust number as necessary
 
       RN
---------
        1
        2
        3
        4
        5
 
5 rows selected.

Report message to a moderator

Previous Topic:	trigger help
Next Topic:	How to call a script with a param issued of a FOR LOOP inside a PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 10:46:48 CDT 2024