what is the difference between implicit and explicit trigger
- 2 Answers
- 22215 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 does sql store data?
What are analytic functions in sql?
What are the methods of filing?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Does execute immediate commit?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Why are sql stored procedures used?
Can we use views in stored procedure?
What is a constraint?
What are the types of functions in sql?
What is the difference between between and in condition operators?
how to select unique records from a table? : Sql dba
What is parameter substitution in sql?
what is sub-query? : Transact sql
Who developed sql?
