what is the difference between implicit and explicit trigger
Answer Posted / 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 View All Answers
Can delete statement be rollbacked?
what is the difference between sql and t-sql? : Transact sql
What are the features of pl sql?
How to get unique records from a table?
what are properties of a transaction? : Sql dba
Is sql easier than java?
What is the advantage of nosql?
What does the sign mean in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Show the two pl/sql cursor exceptions.
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what are all types of user defined functions? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
What is a memo field?
What are all the different normalizations?