Re: Convert block dump data (data type number)
- From: "Tim Hopkins" <oracle-l@xxxxxxxxxxxxxxxxxx>
- To: ax.mount@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Mar 2008 14:22:59 -0000 (GMT)
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
>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
