What are OLD and NEW qualifiers?
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 OLD and NEW qualifiers?
Rating:
The OLD and NEW qualifiers are used to reference the values of a column before and after the data change, respectively.
| INSERT | NULL | Inserted value |
| UPDATE | Value before update | Value after update |
| DELETE | Value before delete | NULL |
The OLD and NEW qualifiers can be used only with row triggers. They cannot be used with statement triggers. The OLD and NEW qualifiers must be prefixed with a colon (:) in every SQL and PL/SQL statement except when they are referenced in a WHEN restricting clause.
Rating:
Was this information helpful?
Other articles
- What is remote dependency?
- What is PL/SQL?
- What is dynamic SQL?
- What is the DBMS_OUTPUT Oracle supplied package?
- How is a trigger compiled?