Convert block dump data (data type number)
From: amonte <ax.mount_at_gmail.com>
Date: Wed, 19 Mar 2008 13:36:47 +0100
Message-ID: <85c1fb130803190536o2ff74bdfs50211bc03a4b7ab7@mail.gmail.com>
from emp
where empno = 7369
Date: Wed, 19 Mar 2008 13:36:47 +0100
Message-ID: <85c1fb130803190536o2ff74bdfs50211bc03a4b7ab7@mail.gmail.com>
Hi
I have dumped a block and trying to see the data it contains, for the varchar2 it's quite simple we simply convert hex to ascii but for number I cant find a suitable way, does anyone know how to convert this data?
select
dbms_rowid.rowid_to_absolute_fno(rowid, 'SCOTT', 'EMP') ABS_FNO, dbms_rowid.rowid_relative_fno(rowid) REL_FNO, dbms_rowid.rowid_block_number(rowid) BLOCKNO, dbms_rowid.rowid_row_number(rowid) ROWNO,empno, ename
from emp
where empno = 7369
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 col 1: [ 5] 53 4d 49 54 48 --> ENAME col 2: [ 5] 43 4c 45 52 4b col 3: [ 3] c2 50 03 col 4: [ 7] 77 b4 0c 11 01 01 01 col 5: [ 2] c2 09 col 6: *NULL* col 7: [ 2] c1 15
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-lReceived on Wed Mar 19 2008 - 07:36:47 CDT