Maximum how many triggers can be updated in table ?
- 5 Answers
- 14549 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
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
What are the predefined tablespaces in a database?
Is it possible to split the print reviewer into more than one region ?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is tns name?
How data locks are respected in oracle?
Does oracle database need java?
What do database buffers contain?
How to start your 10g xe server?
What do you understand by a database object?
Design database draw er diagram for a certain scenario ?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Can we write insert statement in function in oracle?
Describe varray?
What is snapshot is too old? Give and example for better understand.
What is the difference between a hot backup and a cold backup in oracle?
