what is the difference between implicit and explicit trigger
- 2 Answers
- 21453 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / slokh
when we fire any DML operation a memory is alocated. this
memory area is called context area or cursor. data is
retieved and stored in this area
implicit cursors are automatically created by the Oracle.
when you perform any DML operation a memory has been
automatically created, and when the operation is finished
it automatically release the memory space, here every thing
is controlled by the oracle itself.
explicit cursors are the cursors, where the user defined
for which select statement the cursor is being created,
when to fetch the data, and release the memory space. on
other words the control is over the programmer.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
What is function and procedure in pl sql?
What is rtm in testing?
what is a constraint? : Sql dba
What does data normalization mean?
What is pl sql script?
What is the difference between sum and count in sql?
What is the best sql course?
Describe different types of general function used in sql?
What is indexes?
what is the difference between nested subquery and correlated subquery?
What is microsoft t sql?
Is sql pronounced sequel or sql?
How is data stored in sql?
What is the purpose of the primary key?
Can we insert data into materialized view?
