Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a connect identifier?
How many types of segments in Oracle?
How to establish administrator authentication to the server?
What is the difference between translate and replace in oracle?
How do I uninstall oracle 11g?
What are group functions in oracle?
Explain the importance of .pll extension in oracle?
How can you merge two tables in oracle?
What is user managed backup in Oracle?
How to divide query output into groups in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Explain about your project and its relation to the current job position you are applying to?
what is Single Byte Overhead...?
