Creating the Check Approving User Trigger You should create a trigger called TR_CheckApprovingUser.This trigger fires before
updating the approving user number ApprUserNo in the ExpenseReport table. The trigger
body compares the organization number of the approving user to the organization number of
the submitted user. The organization number of the approving user must be the same as the
organization number of the submitting user or the organization number of the parent
organization of the submitting user. If the organization number of the approving user does not
match either, raise an application error.SUBMISSION:
? A script called PART2b.sql which contains SQL or PL/SQL for
? creating the required trigger
? update data of the table for testing trigger我不会写~大家帮我看看~~
解决方案 »
- Oracle存储过程
- 昨天的数据库面试题,请高手指点。
- oracle 正负抵消记录?
- InstallShield打包delphi+oracle的程序
- SQL 基础两问,谢谢
- 菜鸟问题:我在建表时用了primary KEY(a_id),是否还需要建索引?
- 求助Oracle8在Windows2000Server上安装问题!!!
- SQL运行得太慢了,求解决办法
- 接上帖,还剩400分。关于如果建动态列的。http://expert.csdn.net/expert/Topicview2.asp?id=1366852
- Oracle11g透明网关连SQL Server出现“ORA-28545: 连接代理时 Net8 诊断到错误..........”
- 写trigger的时候总是这条错误
- imp出错
BEFORE INSERT
ON TABLE1
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
--
--
--
BEGIN
--
--
--
--
END;
/