what is the difference between implicit and explicit trigger
- 2 Answers
- 21444 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 are two statement types in sql?
What is the difference between Union and Union all. Which is faster.
How do you truncate?
What is the maximum number of rows in sql table?
What is cursor status?
What is sorting in sql?
Can you load data into multiple tables at once? : aql loader
What is the main difference between sql and pl/sql?
what is the difference between delete and truncate statement in sql? : Sql dba
Can you call pl/sql package functions from within a fast formula?
what is online transaction processing (oltp)? : Sql dba
Explain lock escalation? : Transact sql
what is a tablespace? : Sql dba
What are views in sql?
Can we rename a column in the output of sql query?
