这一段时间，在上次的基础上，完成了行迁移、行链接的支持，并且增加了rollback的支持。在数据类型方面，增加了char和timestamp的支持，请看测试：
SUNDOG315>create table t (id1 number,id2 number,id3 number,text1 varchar2(4000),
text2 varchar2(4000),text3 varchar2(4000));
表已创建。
SUNDOG315>insert into t values (1,2,3,lpad('a',4000,'a'),lpad('a',4000,'a'),lpad
('a',4000,'a'));
已创建 1 行。
SUNDOG315>insert into t values (2,3,4,'a','a','a');
已创建 1 行。
SUNDOG315>update t set text1=lpad('a',4000,'a'),text2=lpad('a',4000,'a'),text3=l
pad('a',4000,'a') where id1=2;
已更新 1 行。
SUNDOG315>delete from t;
已删除2行。
SUNDOG315>rollback;
回退已完成。
其中，4000个a太长了，用aaaa...aaaa代替
1798657,00020021000002a4,1003396,56273,1,36,280,TEST,T,insert into T ( ID1, ID2, ID3, TEXT1, TEXT2, TEXT3 ) values ( 1, 2, 3, 'aaaa...aaaa', 'aaaa...aaaa', 'aaaa...aaaa');1798657,00020021000002a4,1003396,56273,1,37,348,TEST,T,insert into T ( ID1, ID2, ID3, TEXT1, TEXT2, TEXT3 ) values ( 2, 3, 4, 'a', 'a', 'a' );
1798661,00020021000002a4,1003396,56273,1,73,308,TEST,T,update T set ID1 = 2, ID2 = 3, ID3 = 4, TEXT1 = 'aaaa...aaaa', TEXT2 = 'aaaa...aaaa', TEXT3 = 'aaaa...aaaa' WHERE ID1 = 2 AND ID2 = 3 AND ID3 = 4 AND TEXT1 = 'a' AND TEXT2 = 'a' AND TEXT3 = 'a' ;
1798662,00020021000002a4,1003394,56273,1,100,228,TEST,T,delete from T where ID1 = 1 AND ID2 = 2 AND ID3 = 3 AND TEXT1 = 'aaaa...aaaa' AND TEXT2 = 'aaaa...aaaa' AND TEXT3 = 'aaaa...aaaa';
1798662,00020021000002a4,1003397,56273,1,127,300,TEST,T,delete from T where ID1 = 2 AND ID2 = 3 AND ID3 = 4 AND TEXT1 = 'aaaa...aaaa' AND TEXT2 = 'aaaa...aaaa' AND TEXT3 = 'aaaa...aaaa';
1798669,00020021000002a4,c00090,0,1,187,260,rollback;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/19423/viewspace-1039152/ ，如需转载，请注明出处，否则将追究法律责任。
