Warning: Trigger created with compilation errors
?create table emp1
? 2 ?(id number(4),
? 3 ?ename varchar2(10),
? 4 ?job varchar2(10),
? 5 ?sal number(7,2));
create trigger bb
? 2 ?after insert
? 3 ?on emp1
? 4 ?declare
? 5 ?degin
? 6 ? ?dbms_output.put_line( 'www' );
? 7 ?end;
? 8 ?/
Warning: Trigger created with compilation errors.
請問這是錯哪里了？
2016-02-04
是begin，不是degin，單詞寫錯了！
CREATE?OR?REPLACE?TRIGGER?bb ??AFTER?INSERT?ON?emp1 DECLARE BEGIN ??dbms_output.put_line('www'); END;