Answers were Sorted based on User's Feedback
Answer / arshi
trigger is autorun query. for example if you perform some
operation that time some operation(insert,delete) shuld be
execute automatically that time you have to use trigger
|Is This Answer Correct ?||7 Yes||0 No|
Answer / vamsi krishna
triggers are the named pl/sql blocks which are executed
automatically at the specified events.the event at which
triggers are executed is called as the triggering
event.there are 3 types of triggers
(i) dml triggers:
these triggers are executed either before or after any dml
events(i.e insert or update or delete)
(ii) ddl triggers:
these triggers are executed either before or after any ddl
events(i.e create or alter or rename or truncate or drop)
(iii) database triggers
these trigger are executed either before or after any
database events(i.e logon or logoff or startup or shutdown)
database triggers can be created only by user having dba
using triggers we can perform the following operations
(i) auto managing of data
(ii) auditing of data
(iii) auditing of events
(iv)defining of validations
|Is This Answer Correct ?||4 Yes||1 No|
How to rebuild an index in oracle?
Is primary key indexed by default in oracle?
How to add a new column to an existing table with a default value?
How to get execution path reports on query statements?
How to retrieve first and last records from a table?
What are triggers?Where are they used?
How do I recompile a procedure in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is redo log?
How to run queries on external tables?
How to save query output to a local file?
How to Select second Maximum salary in a Table ?