OraFAQ Forum: SQL & PL/SQL » Is it possible?

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible?

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

Is it possible? [message #298119]

Tue, 05 February 2008 01:26

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

Report message to a moderator

Re: Is it possible? [message #298120 is a reply to message #298119]

Tue, 05 February 2008 01:27

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, have a look at General forum and Puzzle topic on row generator.

Regards
Michel

Report message to a moderator

Re: Is it possible? [message #298122 is a reply to message #298119]

Tue, 05 February 2008 01:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

yes, no, maybe; I do not know.
Why can not you answer this questio?

Report message to a moderator

Re: Is it possible? [message #298715 is a reply to message #298119]

Thu, 07 February 2008 05:07

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.

Report message to a moderator

Re: Is it possible? [message #298771 is a reply to message #298715]

Thu, 07 February 2008 11:09

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	A Query Which Looks Ahead....
Next Topic:	Returning rows with a condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 08:43:05 CDT 2025