- 论坛徽章:
- 0
|
代码如下:
drop table personal;
create table personal(password varchar(5) not null, NAME varchar2(15) not null, num long, salary number(10), others varchar2(30));
INSERT INTO personal(password, NAME, num, salary, others)VALUES('101', 'GZH', '1', 2400, null);
COMMIT;
CREATE OR REPLACE TRIGGER Writelog1
AFTER DELETE OR UPDATE
ON personal FOR EACH ROW
DECLARE
passwordchar(1);
BEGIN
if UPDATE then
passwordchar := 'U';
else
passwordchar := 'D';
end if;
INSERT INTO writelog VALUES(passwordchar, USER, SYSDATE);
END Writelog1;
SQL>; CREATE OR REPLACE TRIGGER Writelog1
2 AFTER DELETE OR UPDATE
3 ON personal FOR EACH ROW
4 DECLARE
5 passwordchar(1);
6 BEGIN
7 if UPDATE then
8 passwordchar := 'U';
9 else
10 passwordchar := 'D';
11 end if;
12 INSERT INTO writelog VALUES(passwordchar, USER, SYSDATE);
13 END Writelog1;
14 /
警告: 创建的触发器带有编译错误。
请高手指点,谢谢!!!!!!11 |
|