What are conditional predicates?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are conditional predicates?
Rating:
When creating a database trigger, several triggering events can be combined into one by using the INSERTING, UPDATING, and DELETING conditional predicates within the trigger body. In this way, a user can create a trigger that runs a different code based on the type of the triggering statement that fires the trigger. For example, conditional predicates can be used to create a database trigger that restricts all data manipulation events (INSERT, UPDATE, DELETE, etc.) on a table to certain business hours Monday through Friday.
Rating:
Was this information helpful?
Other articles
- What are the advantages of using packages?
- What is a system event trigger?
- What is the syntax for creating a function?
- What is the REMOTE_DEPENDENCIES_MODE parameter?
- What is a bodiless package?
