what is the difference between implicit and explicit trigger
- 2 Answers
- 21413 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 to shutdown mysql server? : Sql dba
How can you create an empty table from an existing table?
How to get each name only once from an employee table?
How you improve the performance of sql*loader? : aql loader
How do you determine the current isolation level? : Transact sql
What is sql query limit?
What are the parts of a basic sql query?
What are the different ways to optimize a sql query?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How do I run a sql query?
What is linq to sql?
What is indexes?
Can we have two clustered index on a table?
What will you get by the cursor attribute sql%rowcount?
Why we use stored procedure instead of query?
