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
- How does Oracle server manage dependencies among objects?
- What are the restrictions regarding the overloading of subprograms?
- What is PL/SQL?
- What is object privilege?
- What is system privilege?