CREATE TABLE t_user (
id int NOT NULL primary key,
password varchar2 (50) NOT NULL ,
name varchar2 (10) NULL
)
/
这是我建立的表,之后
create sequence t_user_seq
increment by 1
start with 1
maxvalue 1000
/
也好使,然后
create or replace trigger t_user_trigger
before insert on t_user
for each row
begin
select t_user_seq.nextval:new.id from dual;
end t_user_trigger
/
就告诉我trigger created with compilation errors.
这是什么原因?哪错了?拜托!
id int NOT NULL primary key,
password varchar2 (50) NOT NULL ,
name varchar2 (10) NULL
)
/
这是我建立的表,之后
create sequence t_user_seq
increment by 1
start with 1
maxvalue 1000
/
也好使,然后
create or replace trigger t_user_trigger
before insert on t_user
for each row
begin
select t_user_seq.nextval:new.id from dual;
end t_user_trigger
/
就告诉我trigger created with compilation errors.
这是什么原因?哪错了?拜托!
before insert on t_user
for each row
begin
select t_user_seq.nextval into:new.id from dual;
end t_user_trigger
trigger created with compilation errors...
为什么?