求哪位大师帮我做下。
不会编
Creating the Expense Amount Exceeding Limit Trigger
You should create a trigger called TR_ExceedingLimitNotice. This trigger fires after
inserting a row in the ExpenseItem table or updating the expense amount (ExpAmt). The
trigger body compares the expense amount to the category limit (ECLimit) in the related row
of the ExpCat table. If the expense amount is greater than the category limit, insert a row into
the exception log table (Log_Table). SUBMISSION:
A script called PART2a.sql which contains SQL or PL/SQL for
1 creating the required trigger
2 inserting data into the table for testing trigger
3 showing the testing results, e.g. SELECT statement against the Log_Table
不会编
Creating the Expense Amount Exceeding Limit Trigger
You should create a trigger called TR_ExceedingLimitNotice. This trigger fires after
inserting a row in the ExpenseItem table or updating the expense amount (ExpAmt). The
trigger body compares the expense amount to the category limit (ECLimit) in the related row
of the ExpCat table. If the expense amount is greater than the category limit, insert a row into
the exception log table (Log_Table). SUBMISSION:
A script called PART2a.sql which contains SQL or PL/SQL for
1 creating the required trigger
2 inserting data into the table for testing trigger
3 showing the testing results, e.g. SELECT statement against the Log_Table
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货