我這麼建表,建sequence,建触发器的:create table tab_curriculum (
cur_id number(8) not null primary key ,/*課程號 */
cur_name varchar(30) not null , /*課程名 */
cur_day date not null /*課時間 */
);
create sequence seq_curr
minvalue 1
start with 1
increment by 1
nocache; create or replace trigger insert_curr
before insert on tab_curriculum
for each row
--declare
-- local variables here
begin
select seq_curr.nextval into :new.cur_id from dual;
end;
cur_id number(8) not null primary key ,/*課程號 */
cur_name varchar(30) not null , /*課程名 */
cur_day date not null /*課時間 */
);
create sequence seq_curr
minvalue 1
start with 1
increment by 1
nocache; create or replace trigger insert_curr
before insert on tab_curriculum
for each row
--declare
-- local variables here
begin
select seq_curr.nextval into :new.cur_id from dual;
end;
select seq_curr.nextval into :new.cur_id from dual;
select seq_curr.nextval into :new.cur_id from dual;
仍然出錯呀!!!ORA--04079:触发器設置無效.
ORA-01861: 字元不符合格式字串
insert into tab_curriculum (cur_id,cur_name,cur_day) values(seq_curr.nextval,'aaa','2002/03/12 09;12;12');
給分...