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
statements.

Is This Answer Correct ?    3 Yes 14 No

Post New Answer

More SQL PLSQL Interview Questions

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  


hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,


What is PL/SQL table ?

6 Answers  


What is the use of function "module procedure" in pl/sql?

0 Answers  


What is the use of stored procedures?

0 Answers  






What is sqlcommand?

0 Answers  


How do I pipe the output of one isql to another?

0 Answers  


I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  


How can I tell if sql is running?

0 Answers  


in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


Define a temp table?

0 Answers  


How to return multiple rows from the stored procedure?

0 Answers  


Categories