Oracle datafile block 格式 说明(二)

2014-11-24 18:45:09 · 作者: · 浏览: 1
t_raw_value('c30b2114',n);


4 dbms_output.put_line(n);


5 end;


6 /


103219


PL/SQL procedure successfullycompleted.



SYS@anqing2(rac2)> declarestr varchar2(100);


2 begin


3 dbms_stats.convert_raw_value('64617665',str);


4 dbms_output.put_line(str);


5 end;


6 /


dave --这个就是 col 1: [ 4] 64 61 76 65 对应的值


PL/SQL procedure successfullycompleted.



end_of_block_dump


End dump data blocks tsn: 0file#: 1 minblk 292689 maxblk 292689


[oracle@rac2 ~]$