Re: Convert block dump data (data type number)

From: amonte <ax.mount_at_gmail.com>
Date: Wed, 19 Mar 2008 23:19:20 +0100
Message-ID: <85c1fb130803191519n6e9a1794m820d1c50d4b7fda3@mail.gmail.com>


Hi

Thanks for the replies

Does anyone know what does internally do

dbms_stats.convert_raw_value and utl_raw.cast_to_number?

Thanks

Alex

On Wed, Mar 19, 2008 at 3:22 PM, Tim Hopkins <oracle-l_at_timothyhopkins.net> wrote:

> Hi Alex,
>
> You can convert the raw hex to a number using the UTL_RAW package:
>
> SQL> select utl_raw.cast_to_number(replace('c2 4a 46',' ')) from dual;
>
> UTL_RAW.CAST_TO_NUMBER(REPLACE('C24A46',''))
> --------------------------------------------
> 7369
>
>
> 1 row selected.
>
> Cheers,
> Tim
>
> > On Wed, Mar 19, 2008 at 1:36 PM, amonte <ax.mount_at_gmail.com> wrote:
> >
> >> Hi
> >>
> >
> >> ABS_FNO REL_FNO BLOCKNO ROWNO EMPNO ENAME
> >> ---------- ---------- ---------- ---------- ---------- ----------
> >> 8 8 10 0 7369 SMITH
> >>
> >> so I dump block 10 and check for row 0 and got this:
> >>
> >> tab 0, row 0, @0xb94
> >> tl: 38 fb: --H-FL-- lb: 0x0 cc: 8
> >> col 0: [ 3] c2 4a 46 --> EMPNO
> >>
> >> so converting 53 4d 49 54 48 to ascii we got SMITH but to get the EMPNO
> >> (7369) using c2 4a 46 ?
> >>
> >> TIA
> >>
> >> Alex
> >>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 19 2008 - 17:19:20 CDT

Original text of this message