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
How to export data to a csv file?
What do you mean by merge in oracle?
What to do if dba lost the system password?
What privilege is needed for a user to query tables in another schema?
What is background process in Oracle?
How to list all user accounts in oracle?
How do we display rows from the table without duplicates?
What is format trigger?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is instant client oracle?
How to use fetch statement in a loop?
What do you mean by merge in oracle and how can you merge two tables?
How to create lov dynamically at runtime & attach to text field?
what is meant by magic query
What privilege is needed for a user to insert rows to tables in another schema?