CREATE OR REPLACE TRIGGER your_trigger_name
BEFORE INSERT
ON your_table
FOR EACH ROW
DECLARE
L_ID NUMBER;
BEGIN
SELECT NVL(MAX(ID),0) INTO L_ID FROM your_table;
:NEW.ID:=L_ID+1;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
/
BEFORE INSERT
ON your_table
FOR EACH ROW
DECLARE
L_ID NUMBER;
BEGIN
SELECT NVL(MAX(ID),0) INTO L_ID FROM your_table;
:NEW.ID:=L_ID+1;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
/
create sequence seq_id
minvalue 1
start with 1
increment by 1;insert into table tablename values(seq_id.nextval,....);
~~~是什么用的.能给我解释一下吗 ?
我都看的不是很明白 刚学
谢谢