Home » SQL & PL/SQL » SQL & PL/SQL » To retrive particular row from a table?
To retrive particular row from a table? [message #232706] Mon, 23 April 2007 01:26 Go to next message
kavi_kalidhas
Messages: 2
Registered: September 2006
Junior Member
How to retrieve particular row from a table without using ROWID and ROWNUM? Can any one pls explain the logic with perfect example?
Re: To retrive particular row from a table? [message #232708 is a reply to message #232706] Mon, 23 April 2007 01:27 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
WHY? PLS EXPLAIN.

MHE
Re: To retrive particular row from a table? [message #232709 is a reply to message #232708] Mon, 23 April 2007 01:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

http://www.orafaq.com/forum/t/59966/91729/
Re: To retrive particular row from a table? [message #232711 is a reply to message #232709] Mon, 23 April 2007 01:28 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Thank you tahpush!

MHE
Re: To retrive particular row from a table? [message #232716 is a reply to message #232711] Mon, 23 April 2007 01:31 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Always glad to be of service Laughing
Re: To retrive particular row from a table? [message #232722 is a reply to message #232706] Mon, 23 April 2007 01:52 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use WHERE.

Regards
Michel
Previous Topic: packages
Next Topic: select first 50 records
Goto Forum:
  


Current Time: Sun Dec 04 10:44:59 CST 2016

Total time taken to generate the page: 0.08405 seconds