After and before____oracle in triggers in Oracle

Source: Internet
Author: User

1. What's the difference between after and before in a trigger in Oracle?
One is triggered before the record operation, and one is triggered after the record operation.

2. What occasions are used separately
For example, the definition between the table has a foreign key, delete the primary key, you must first delete the foreign key table, then there are successively points.

3, there is also a statement-level trigger and row-level trigger what is the difference.
If defined as the statement level, when the delete from T executes, the trigger runs only once, and if it is defined as a row level, the above delete operation causes the stylus to run multiple times (several records are run a few times).


Add upstairs
Inserting action: New
Update operation: New,:old, if updating a field triggers the use of If updating (' col ') then ...
Delete operation: Old

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.