OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » rowid

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

rowid [message #19788]

Wed, 10 April 2002 01:42

krishna
Messages: 141
Registered: October 1998

Senior Member

Hi ,

I have a table emp.
now i want to see where are my rows stored.(not the information in the row,i want the information used to fetch the row when given a query)
That is each row is given a row id?where to see this?and this should point to some thing like a datablock or something where my row is located?
Can anybody give me the clear description on this(with datadictionary views)
thanks

Report message to a moderator

Re: rowid [message #19800 is a reply to message #19788]

Wed, 10 April 2002 09:20

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

I would refer you to the docs for a thorough explanation of rowids:

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#46150

To see the rowids for a table, add the pseudocolumn rowid to your select list:

sql>select rowid, user_id
  2    from user_master
  3   where rownum <= 3;
 
ROWID              USER_ID
------------------ ----------
AAACF1AAQAAADOfAAA oliverm
AAACF1AAQAAADOfAAB gracesd
AAACF1AAQAAADOfAAC racetta

Report message to a moderator

Previous Topic:	Re: Calling stored procedures in visual Basic
Next Topic:	cursors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:14:18 CDT 2024