Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Mapping tablerow to datablock?

Re: Mapping tablerow to datablock?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 24 Mar 2004 11:48:32 +0000 (UTC)
Message-ID: <c3rsig$bhb$1@titan.btinternet.com>

The ROWID contains the information.
Check the dbms_rowid package to see
how to extra the details from it.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland  http://www.index.is/oracleday.php
June  2004      UK - Optimising Oracle Seminar


"grz02" <grz01_at_spray.se> wrote in message
news:1641ee43.0403240334.7f43dbd2_at_posting.google.com...

> Hi,
> Given a table-row in Oracle, is there any way to see in which
> datablock it is stored?
> Does the ROWID purvey this info, or any other way?
> Thanks,
Received on Wed Mar 24 2004 - 05:48:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US