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
阅读全文

浙公网安备 33010602011771号