Check dbms_stats.convert_raw_value.

I don't know when this set of procedures
was introduced, but they can be used to
take a raw input (e.g. your c403135456)
and decode it into a variable of the correct
type.


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

March 2004 Hotsos Symposium - The Burden of Proof
Dynamic Sampling - an investigation
March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial
April 2004 Iceland
June 2004    UK - Optimising Oracle Seminar


----- Original Message -----
From: "Mark Moynahan" <Mark.Moynahan@(protected)>
To: <oracle-l@(protected)>
Sent: Wednesday, March 03, 2004 3:31 PM
Subject: Question about block dump


> When doing a block dump is there a way to determine the rowid you're
looking
> for? What if the first column in each row a primary key and has a number
> datatype. Could that first column be used to determine the row your
looking
> for? If so, how are number datatypes stored internally in Oracle?
>
> for instance, in the trace file the first column looks like this:
> col 0: [ 5] c4 03 13 54 56
>
> How would I convert this to the actual number in the primary key column?
>
> Thanks,


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------