当前位置: 动力学知识库 > 问答 > 编程问答 >

oracle - What is the meaning of "fail the trigger"?

问题描述:

I have this problem to solve in Oracle:

The trigger should be fired before data is inserted, updated, or deleted in a row in the ITEM table. When a row is changed in the ITEM table, check to see if that row exists in the ORD table. If the SHIPDATE column has a value in the ORD table, fail the trigger.

What does "fail the trigger" mean? I am really confused.

I do not know whether it means that I would not update the table anymore,

or I would just raise an error message.

网友答案:

It sounds like this is a homework problem. If so, you would really want to ask your professor to clarify the assignment. We can guess but our guess may not match what the professor wants.

I would guess that the professor is asking you to raise an exception in the trigger.

分享给朋友:
您可能感兴趣的文章:
随机阅读: