1、建立一个序列发生器seq1 create sequence seq1 start with 1 maxvalue 999999;2、创表: CREATE TABLE TAB1 (A NUMBER(4) PRIMARY KEY, B VARCHAR2(100))3、向表中录入数据: insert into tab1(a,b) values(seq1.nextval,'TEST'); 每次录入数据时用seq1.nextval这样取就可以了。
一。创建序列 CREATE SEQUENCE TEST INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER二 USERADD 会员触发器CREATE OR REPLACE TRIGGER USERADD BEFORE INSERT ON MEMBERRG FOR EACH ROW BEGIN SELECT text.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;
create sequence s_tb_report_id increment by 1 start with 1 maxvalue 999999999;insert into s_tb_report (report_id,...) values (s_tb_report_id.nextval,...)
1 Create Sequence CREATE SEQUENCE SEQ_FOR_ID START WITH 1; 2 Create Table CREATE TABLE note ( note_id number(8), note_text varchar2); 3 Insert data INSERT INTO note (SEQ_FOR_ID.NEXTVAL,"NOTETEXT"); 4 OVER
create sequence seq1
start with 1
maxvalue 999999;2、创表: CREATE TABLE TAB1
(A NUMBER(4) PRIMARY KEY,
B VARCHAR2(100))3、向表中录入数据:
insert into tab1(a,b)
values(seq1.nextval,'TEST'); 每次录入数据时用seq1.nextval这样取就可以了。
CREATE SEQUENCE TEST INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER二 USERADD 会员触发器CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
SELECT text.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;
CREATE SEQUENCE SEQ_FOR_ID
START WITH 1;
2 Create Table
CREATE TABLE note
( note_id number(8),
note_text varchar2);
3 Insert data
INSERT INTO note (SEQ_FOR_ID.NEXTVAL,"NOTETEXT");
4 OVER