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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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 > >> > > >