Answer Posted / ashish
Triggers are stored procedures created in order to enforce
integrity rules in a database. A trigger is executed every
time when database modification done.
Triggers are executed automatically on occurance of one of
the data-modification operations.
A trigger is a database object directly associated with a
particular table. It fires whenever a specific
statement/type of statement is issued against that table.
The types of statements are insert,update,delete and query
statements.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What privilege is needed for a user to create views in oracle?
What is the difference between PFILE and SPFILE in Oracle?
Can we protect our pl/sql source code?
Explain the use of ignore option in imp command.
How to fetch the row which has the max value for a column?
What are temporal data types in oracle?
How to export several tables together?
How to view existing locks on the database?
Name the three major set of files on disk that compose a database in Oracle?
What are the different windows events activated at runtime ?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What would you do with an in-doubt distributed transaction?
Explain a data segment?
How to export your connection information to a file?
How to display employee records who gets more salary than the average salary in the department?