ABC三个表，均有ID作为主键，code作为信息标识，VER作为信息的版本同一code可在表中有多条记录，但每条记录的VER均不相同每张表里除这三个字段外均有不同的属性字段，表结构如下：CREATE TABLE A(IDVARCHAR2(5 BYTE),CODEVARCHAR2(10 BYTE),P1VARCHAR2(20 BYTE),VERNUMBER(6),CONSTRAINT PK_APRIMARY KEY(ID));CREATE TABLE B(IDVARCHAR2(5 BYTE),CODEVARCHAR2(10 BYTE),P2VARCHAR2(20 BYTE),VERNUMBER(6),CONSTRAINT PK_BPRIMARY KEY

贴在开发板了 :)http://www.itpub.net/viewthread.php?tid=1059418

Test Case：＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋CREATE TABLE TestCode(IDVARCHAR2(5),VALNUMBER(1));select * from (select rownum id, decode(sign(dbms_random.value-0.9),-1,0,1) valfrom dual connect by rownum0;insert into testcode select * from (select rownum id, decode(sign(dbms_random.value-0.9),-1,0,1) valfrom dual connect by rownum0;select * from testcode;＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋

:) :)排队欢迎 :rose:

:)欢迎欢迎:rose: