09 2009 档案

摘要:0、添加字段ALTER TABLE T_CUST ADD ID number1、创建表CREATE TABLE T_CUST(CUST_ID INT NOT NULL,CUST_NAME VARCHAR2(20) NOT NULL,CONSTRAINT PK_T_CUST PRIMARY KEY (CUST_ID));2、创建序列CREATE SEQUENCE S_CUST_IDMINVALUE 1MAXVALUE 10000000START WITH 1INCREMENT BY 1NOCACHE;3、试试序列是否起作用INSERT INTO T_CUST(CUST_ID, CUST_NAME 阅读全文
posted @ 2009-09-01 15:42 DANNY 阅读(576) 评论(0) 推荐(1)