Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible?
Is it possible? [message #298119] Tue, 05 February 2008 01:26 Go to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Dear Friends,

I am looking dual table can have only one row.

But my friend told like below

Is it possible to generate sequence numbers in dual table

1
2
3
4
5
6
7
.
.
.
.

Advance Thanks

Mano
Re: Is it possible? [message #298120 is a reply to message #298119] Tue, 05 February 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, have a look at General forum and Puzzle topic on row generator.

Regards
Michel
Re: Is it possible? [message #298122 is a reply to message #298119] Tue, 05 February 2008 01:28 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
yes, no, maybe; I do not know.
Why can not you answer this questio?
Re: Is it possible? [message #298715 is a reply to message #298119] Thu, 07 February 2008 05:07 Go to previous messageGo to next message
prawinrajkumar
Messages: 2
Registered: February 2008
Junior Member
Dear Mano,

Try this row generator,

Select level from dual
connect by level<=N;

where N stands for any positive number;

Regards,
Prawin.
Re: Is it possible? [message #298771 is a reply to message #298715] Thu, 07 February 2008 11:09 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.

2/ Don't give solution in newbie forum, just give hint/clue/way to find a solution

Regards
Michel
Previous Topic: A Query Which Looks Ahead....
Next Topic: Returning rows with a condition
Goto Forum:
  


Current Time: Mon Dec 05 19:20:40 CST 2016

Total time taken to generate the page: 0.16962 seconds