1.建立表格:
CREATE TABLE Table1
(
ID NUMBER(8) NOT NULL,
Others VARCHAR2(20)
);
2.建立从1开始的序列:
CREATE SEQUENCE myID
INCREMENT BY 1 NO MAXVALUE MINVALUE 1;
3.建立触发器:
CREATE OR REPLACE TRIGGER myTGR
BEFORE INSERT ON Table1 FOR EACH ROW
BEGIN
SELECT myID.NextVAl INTO :new.ID FROM dual;
END;
1.建立表格:
CREATE TABLE Table1
(
ID NUMBER(8) NOT NULL,
Others VARCHAR2(20)
);
2.建立从1开始的序列:
CREATE SEQUENCE myID
INCREMENT BY 1 NO MAXVALUE MINVALUE 1;
3.建立触发器:
CREATE OR REPLACE TRIGGER myTGR
BEFORE INSERT ON Table1 FOR EACH ROW
BEGIN
SELECT myID.NextVAl INTO :new.ID FROM dual;
END;
1.建立表格:
CREATE TABLE Table1
(
ID NUMBER(8) NOT NULL,
Others VARCHAR2(20)
);
2.建立从1开始的序列:
CREATE SEQUENCE myID
INCREMENT BY 1 NO MAXVALUE MINVALUE 1;
3.建立触发器:
CREATE OR REPLACE TRIGGER myTGR
BEFORE INSERT ON Table1 FOR EACH ROW
BEGIN
SELECT myID.NextVAl INTO :new.ID FROM dual;
END;