-
2008-10-07 12:46:05
/ Oracle开发
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
查看(414)
评论(21)
-
2008-09-20 22:14:14
/ Oracle数据库管理
贴在开发板了 :)http://www.itpub.net/viewthread.php?tid=1059418
查看(86)
评论(0)
-
2008-09-20 22:07:55
/ Oracle开发
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;+++++++++++++++++++++++++++++++++
查看(610)
评论(25)
-
2008-09-04 12:50:12
/ 软件测试
:) :)排队欢迎 :rose:
查看(250)
评论(8)
-
2008-09-04 12:49:16
/ 项目过程
:)欢迎欢迎:rose:
查看(476)
评论(13)