Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 22807 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 t sql in sql server?
Explain clause in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How can triggers be used for the table auditing?
What are different functions in sql?
How to fix oracle error ora-00942: table or view does not exist
what is a stored procedure? : Sql dba
What is varray in pl sql?
What are pl/sql cursors?
What does seeding a database mean?
What are the advantages of pl sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
How to select random rows from a table?
Why do we use subquery?
Is and as keyword in pl sql?
