Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 23078 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
How can I speed up sql query?
What is forward declaration in pl sql?
What is function and procedure?
Does group by remove duplicates?
what is a unique key ? : Sql dba
What is the purpose of cursors in pl/sql?
How show all rows in sql?
How do I use google cloud in sql?
How do you optimize a stored procedure query?
How do you truncate?
What are the disadvantages of not performing database normalization?
What does a pl/sql package consist of?
what is clause? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
What are the steps for performance tuning.
