Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is the difference between implicit and explicit trigger

Answers were Sorted based on User's Feedback

what is the difference between implicit and explicit trigger..

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

what is the difference between implicit and explicit trigger..

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
CURSOR...IS statement.

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

Post New Answer

More SQL PLSQL Interview Questions

Can a primary key be a foreign key?

0 Answers  

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

What is correlated sub-query?

7 Answers   Oracle,

What are triggers and its uses?

0 Answers  

What is rank dense_rank and partition in sql?

0 Answers  

How do you update a value in sql?

0 Answers  

Is sql difficult?

0 Answers  

Is oracel sql developer written in java?

0 Answers  

What is your daily office routine?

0 Answers   Data Vision,

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

What is exception? What are the types of exceptions?

0 Answers  

Is sql workbench free?

0 Answers