[阅读: 342] 2004-09-20 03:48:11
我创建表,能作sql/plus 中做吗?
怎么做呢?
CREATE TABLE FFJT.YSJL1
(QUALITYID CHAR(5 byte) NOT NULL,
FACTORYID CHAR(5 byte) NOT NULL,
CUSTOMERID CHAR(5 byte) NOT NULL,
VARIETYID CHAR(3 byte) NOT NULL,
BATCH NUMBER(3) NOT NULL,
TRANSPORTMODE CHAR(4 byte) NOT NULL,
VEHICLEAMOUNT NUMBER(2) NOT NULL,
TONAMOUNT NUMBER(4) NOT NULL,
NDATE DATE NOT NULL,
AAD NUMBER(4,
2),
QBAD NUMBER(5, 3),
STAD NUMBER(3, 2),
MT NUMBER(4),
VAD NUMBER(4),
CRC NUMBER(1),
GRI NUMBER(3),
YMM
NUMBER(3, 1),
MAD NUMBER(4, 2),
THEORYYIELD NUMBER(4, 2),
AD NUMBER(4, 2),
QNET1 NUMBER(4, 2),
QNET2 NUMBER(4,
2),
STD NUMBER(3, 2),
VDAF NUMBER(4, 2),
ASSESSOR
CHAR(10 byte) NOT NULL,
LISTER CHAR(10 byte) NOT NULL,
ASSAYMAN
CHAR(10 byte) NOT NULL,
ASSESSORSIGN" CHAR(2 byte) DEFAULT '00' NOT NULL)
.
CENTER><IMG SRC='http://www.cz88.net/ip/pic_1.aspx' BORDER='0'></IMG></CENTER>