ORACLE update 操作内部原理(2)

发表于:2013-10-11来源:IT博客大学习作者:惜分飞点击数: 标签:oracle
SQL commit; Commit complete. SQL alter system checkpoint; System altered. SQL alter system dump datafile 4 block 175; System altered. SQL select dump(XIFENFEI,16) from dual; DUMP(XIFENFEI,16) --------

  SQL> commit;

  Commit complete.

  SQL> alter system checkpoint;

  System altered.

  SQL> alter system dump datafile 4 block 175;

  System altered.

  SQL> select dump('XIFENFEI','16') from dual;

  DUMP('XIFENFEI','16')

  -------------------------------------

  Typ=96 Len=8: 58,49,46,45,4e,46,45,49

  我们可以但看到值有XFF改变为XIFENFEI,存储长度变大

原文转自:http://blogread.cn/it/article/5666