Maximum how many triggers can be updated in table ?
Answer Posted / ora
System Privileges Related To Table Triggers
create trigger
create any trigger
administer database trigger
alter any trigger
drop any trigger
Table Trigger Firing Options
-- before constraints are applied
BEFORE INSERT
BEFORE UPDATE
BEFORE DELETE
-- after constraints are applied
AFTER INSERT
AFTER UPDATE
AFTER DELETE
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How do I manually create a database in oracle?
Explain the types of exception?
Explain what does a control file contain?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How a tablespace is related to data files?
How would you change old and new values in an insert, delete and update triggers?
What is tns name?
IS it possible to built the oracle database without setting the kernal parameters?
What is a view and how is it different from a table?
State and explain the different types of data models?
How to convert characters to dates in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the function of optimizer in oracle?
What is a schema in oracle?