Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 22957 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 the purpose of normalization?
How delete a row in sql?
what is rdbms? : Sql dba
Can I call a procedure inside a function?
What is an exception in PL/SQL? What are the two types of exceptions?
How do I view stored procedures?
Can a trigger call a stored procedure?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Explain correlated query work?
What is t-sql? : Transact sql
How do I view output in sql developer?
How many triggers can be applied on a table?
What is audit logout in sql profiler?
Explain the difference between sql and mysql.
What are hotfixes and patches?
