Oracle/PLSQL: AFTER DELETE Trigger
来源:互联网 发布:apache ant 1.8.2 编辑:程序博客网 时间:2024/05/01 03:48
Oracle/PLSQL: AFTER DELETE Trigger
An AFTER DELETE Trigger means that Oracle will fire this trigger after the DELETE operation is executed.
译:AFTER DELETE表示在DELETE操作执行后,ORACLE会引发该触发器
The syntax for an AFTER DELETE Trigger is:
译:AFTER DELETE触发器的语法如下:
CREATE or REPLACE TRIGGER trigger_name
AFTER DELETE
ON table_name
[ FOR EACH ROW ]
DECLARE
-- variable declarations
BEGIN
-- trigger code
EXCEPTION
WHEN ...
-- exception handling
END;
AFTER DELETE
ON table_name
[ FOR EACH ROW ]
DECLARE
-- variable declarations
BEGIN
-- trigger code
EXCEPTION
WHEN ...
-- exception handling
END;
trigger_name is the name of the trigger to create.
译:trigger_name表示创建的触发器名
Restrictions:
· You can not create an AFTER trigger on a view.
· You can not update the :NEW values.
· You can not update the :OLD values.
译:
限制:
· 不能够在视图上创建AFTER触发器。
· 不能够更新 :NEW 的值。
· 不能够更新 :OLD 的值。
For example:
If you had a table created as follows:
译:如果你有一个如下的表:
CREATE TABLE orders
(
order_id
number(5),
quantity
number(4),
cost_per_item
number(6,2),
total_cost
number(8,2)
);
We could then create an DELETE UPDATE trigger as follows:
译:我们像下面这样创建一个DELETE UPDATE触发器:
CREATE OR REPLACE TRIGGER orders_after_delete
AFTER DELETE
ON orders
FOR EACH ROW
AFTER DELETE
ON orders
FOR EACH ROW
DECLARE
v_username varchar2(10);
v_username varchar2(10);
BEGIN
-- Find username of person performing the DELETE on the table
SELECT user INTO v_username
FROM dual;
SELECT user INTO v_username
FROM dual;
-- Insert record into audit table
INSERT INTO orders_audit
( order_id,
quantity,
cost_per_item,
total_cost,
delete_date,
deleted_by)
VALUES
( :old.order_id,
:old.quantity,
:old.cost_per_item,
:old.total_cost,
sysdate,
v_username );
INSERT INTO orders_audit
( order_id,
quantity,
cost_per_item,
total_cost,
delete_date,
deleted_by)
VALUES
( :old.order_id,
:old.quantity,
:old.cost_per_item,
:old.total_cost,
sysdate,
v_username );
END;
- Oracle/PLSQL: AFTER DELETE Trigger
- AFTER DELETE Trigger
- after delete trigger
- oracle trigger中的before和after
- Oracle —— before row trigger OR after row trigger
- oracle创建trigger procedure function sequence plsql
- PLSQL-trigger
- PLSQL Trigger
- PLSQL Trigger :OLD :NEW
- PLSQL Trigger Dynamic SQL
- PLSQL DDL Trigger
- PLSQL Logon Trigger
- PLSQL Logoff Trigger
- trigger oracle
- Oracle Trigger
- Oracle Trigger
- Oracle Trigger
- Oracle Trigger
- Hook NDIS.SYS入口
- MapInfo介绍
- 学习笔记[1]——Singleton(单件)模式
- 国际:个人网页中必不可少的十五大Web API
- 今天初步实现先Request然后Connect
- Oracle/PLSQL: AFTER DELETE Trigger
- 加强用户密码保存及检验的安全性
- MiddleGen配置
- Oracle体系结构需要了解的两个概念
- SQL: ORDER BY Clause
- RichTextBox的缩进
- 中国石油A股发行价确定 15--16.7元是让利于民
- ssh远程复制命令scp的用法
- 有一个数组内放10个整数要求找出最小的数&它的下标然后将它&数组中最前面的元素对换