Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Answer Posted / nishi
a. ON-INSERT b. POST-INSERT c. PRE-INSERT
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
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?
Define oracle database
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Give the different types of rollback segments.
How can you merge two tables in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain alias?
What is difference between cartesian join and cross join?
Why do we use coalesce function in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is an oracle data file?
How to create a temporary table in oracle?
what is dynamic SGA and static SGA
What are the ways tablespaces can be managed and how do they differ?