create sequence sequencename start with 1 maxvalues 1000 nocycle nocache
insert into tablename values (sequencename.nextval,...)
用序列很容易实现
insert into tablename values (sequencename.nextval,...)
用序列很容易实现
调试欢乐多
rs.open .........strSQL="insert into myid values "&rs(myid)
rs.close
只是思想,具体的自己实现试试
:-)
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
SELECT USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;
name varchar(20));--先创建表create or replace trigger mytrigger
before insert
on mytable
for each row
declare
maxid mytable.id%type;
begin
select max(id) into maxid from mytable;
:new.id:=maxid+1;
dbms_output.put_line(maxid);
end;--触发器