全部博文(136)
分类: Oracle
2008-05-15 23:32:44
我们先回顾一下 Row Data 中的信息:
-- Row Data block_row_dump: tab 0, row 0, @0x1eff tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 1, @0x1ef6 tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 2, @0x1eed tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 3, @0x1ee4 tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 4, @0x1edb tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 5, @0x1ed2 tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 6, @0x1ec9 tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 tab 0, row 7, @0x1ec0 tl: 7 fb: --H-FL-- lb: 0x2 cc: 1 col 0: [ 3] c2 07 43 end_of_block_dump End dump data blocks tsn: 11 file#: 11 minblk 226 maxblk 226 |
SQL> select * from test3; B ---------- 666 666 666 666 666 666 已选择6行。 SQL> |
SQL> select my_tool.get_inner('[ 3] c2 07 43', 'n') b from dual; B --------- 666 |