What are triggers?Where are they used?
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
privileges.
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 |
A set of PLSQL statements "automatically" executed when DML
statements are performed and stored parmanently in database.
USES:- used to impose user defined restrictions or business
rules on database table
Is This Answer Correct ? | 1 Yes | 1 No |
what are the differen between key flexifild and discriptive fiexifild.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is MTTR advisor in Oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
how to select second mauximum value in a given table under salary column
What to do if the startbd.bat failed to start the xe instance?
types of indexes and the rationale behind choosing a particular index for a situation.
Explain an index segment?
Difference between open_form and call_form in oracle.
Explain the use of indexes option in exp command.
How to create a stored procedure in oracle?
How to create a single index for multiple columns?