OraFAQ Forum: Training & Certification » Level in sequence query..

Home » Other » Training & Certification » Level in sequence query..

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

Level in sequence query.. [message #260366]

Sun, 19 August 2007 02:25

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

hello DBA Gurus,

in the answer of thread http://www.orafaq.com/forum/t/87493/102855/
, in the select query for fetching next value, LEVEL clause is used in where clause..

I dont know about that, neither i came to read about it during studying the sequence..
Can anyone please tell me its purpose and use or state some online material where i can study it..

Thanking you..

Dipali

Report message to a moderator

Re: Level in sequence query.. [message #260377 is a reply to message #260366]

Sun, 19 August 2007 06:26

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

Senior Member
Account Moderator

It has nothing to do with sequence, it is just a row generator.
Don't think connect as an independant clause.
Consider the whole "select level from dual connect by level <= N" as an instruction to generate N rows.

Regards
Michel

Report message to a moderator

Re: Level in sequence query.. [message #260395 is a reply to message #260377]

Sun, 19 August 2007 09:23

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

Thanks michel cadot..
so,

"connect by level <= N"

means This clause is used to get N number of rows (as we use rownum for that purpose) .

Am i interpreating right, mr cadot??

Regads..
Dipali

Report message to a moderator

Re: Level in sequence query.. [message #260402 is a reply to message #260395]

Sun, 19 August 2007 09:55

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

Senior Member
Account Moderator

No.
"select level from dual connect by level <= N"
is used to get N rows.
It is a whole and one statement.

Regards
Michel

Report message to a moderator

Re: Level in sequence query.. [message #260403 is a reply to message #260402]

Sun, 19 August 2007 10:06

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

this is new thing to learn for me.. Smile

Thanks michel...

regards..
Dipali

Report message to a moderator

Previous Topic:	regarding crusors,procedure & functions?
Next Topic:	Password Verify Function.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:34:54 CDT 2024