17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger zuocheng_id
before insert on zuocheng
for each row
begin select zc.nextval into :new.id from dual;
end;
/
然后 show error 看有什么错误
-- 你的语句没有问题的
SQL> create table zuocheng(id int,address char(25), pay int);
Table created
SQL> --创建自增列
SQL> create sequence zc increment by 1 start with 1 minvalue 1 nomaxvalue nocache;
Sequence created
SQL> --创建触发器
SQL> create or replace trigger zuocheng_id
2 before insert on zuocheng
3 for each row begin
4 select zc.nextval into :new.id from dual;
5 end;
6 /
Trigger created
SQL> --添加数据语句
SQL> insert into ZUOCHENG(ADDRESS,PAY) values('aaaaa',345);
1 row inserted
SQL> insert into ZUOCHENG(ADDRESS,PAY) values('bbbbb',567);
1 row inserted
SQL> select * from ZUOCHENG ;
ID ADDRESS PAY
---------- ---------- ----------
1 aaaaa 345
2 bbbbb 567
SQL> drop table ZUOCHENG purge ;
Table dropped
SQL> drop sequence zc;
Sequence dropped
SQL>