what is the difference between implicit and explicit trigger
Answers were Sorted based on User's Feedback
Answer / 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|
Answer / gaurav gupta
However,queries that return more than one row you must
declare an explicit cursor or use a cursor FOR loop.
Explicit cursor is a cursor in which the cursor name is
explicitly assigned to a SELECT statement via the
An implicit cursor is used for all SQL statements Declare,
Open, Fetch, Close. An explicit cursors are used to process
multirow SELECT statements An implicit cursor is used to
process INSERT, UPDATE, DELETE and single row SELECT. .INTO
|Is This Answer Correct ?||3 Yes||14 No|
Can a primary key be a foreign key?
how many tables will create when we create table, what are they? : Sql dba
What is correlated sub-query?
What are triggers and its uses?
What is rank dense_rank and partition in sql?
How do you update a value in sql?
Is sql difficult?
Is oracel sql developer written in java?
What is your daily office routine?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
What is exception? What are the types of exceptions?
Is sql workbench free?