OraFAQ Forum: Forms » PLease clarify my doubt it's urgent

Home » Developer & Programmer » Forms » PLease clarify my doubt it's urgent

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

PLease clarify my doubt it's urgent [message #86236]

Mon, 13 September 2004 23:07

pratyusha
Messages: 8
Registered: July 2004

Junior Member

Select * from table1 where rownum=1 will work and Select * from table1� where rownum < 2��will work, where as Select * from table1 where rownum=2 doesnt work� can any body pls tell me the reason...

�

�

Report message to a moderator

Re: PLease clarify my doubt it's urgent [message #86241 is a reply to message #86236]

Tue, 14 September 2004 05:29

karthi
Messages: 42
Registered: December 2000
Location: B'lore

Member

hi,

Greater than also we can't use in rownum. Rownum assigns temporary numbering, not like rowid.
execute these 3 queries, then u can understand
1. Select empno,rownum from emp;
2. select empno,rownum from emp where deptno =10;
3. select empno,rownum from emp where deptno =20;

Here in every query rownum changes. hope u got it.

Report message to a moderator

Re: PLease clarify my doubt it's urgent [message #86701 is a reply to message #86236]

Wed, 20 October 2004 21:55

Manjunath
Messages: 9
Registered: July 2000

Junior Member

Hello Sir/Madam.I am a commerce graduate.i am doing Articleship with the Auditor. will this experience work to apply for any MNC's and other companies.Pls reply as early as possible
Thanking You
manju

Report message to a moderator

Previous Topic:	how to set and get subcolumn in spread table(mmtx.ocx)
Next Topic:	Length of the field data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 17:29:51 CDT 2024