Oracle建触发器问题

Question

create table M_TRANSACTION_TYPE
(
OPERATION_ID number primary key,
OPERATION_TYPE number,
OPERATION_TIME date,
CRM_ID varchar2(36),

);

create sequence M_TRANSACTION_TYPE_SEQ nocycle;

create or replace M_TRANSACTION_TYPE_TRIGGER
before insert on M_TRANSACTION_TYPE
for each row
begin
select M_TRANSACTION_TYPE_SEQ.NEXTVAL into :new.OPERATION_ID from dual;
end;

请问这个有什么问题，执行的时候出现，执行完毕，但带有警告；导致我下面sql脚本无法执行。

Answer 1

我全部看了一下，有两处错误：
1.像楼上"demojava"说的，建table时最后多了一个逗号
2.create trigger的时候少了trigger关键字

所以，改成这样后我试验是成功的：
[code="sql"]
create table M_TRANSACTION_TYPE
(
OPERATION_ID number primary key,
OPERATION_TYPE number,
OPERATION_TIME date,
CRM_ID varchar2(36)
);

create sequence M_TRANSACTION_TYPE_SEQ nocycle;

create or replace trigger M_TRANSACTION_TYPE_TRIGGER
before insert on M_TRANSACTION_TYPE
for each row
begin
select M_TRANSACTION_TYPE_SEQ.NEXTVAL into :new.OPERATION_ID from dual;
end;

[/code]

以上仅供参考