what is the difference between implicit and explicit trigger
- 2 Answers
- 22233 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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
What is the unique index?
Explain mutating table error.
In what condition is it good to disable a trigger?
What does select count (*) mean in sql?
How do I trace sql profiler?
Explain exception handling in pl/sql?
What are the different types of joins in sql?
What is the use of desc in sql?
Write an sql query to select all records from the table?
What is an exception in pl/sql?
How to run sql statements with oracle sql developer?
What is the difference between functions, procedures, and packages in pl/sql?
what is table? : Sql dba
what is 'mysqlimport'? : Sql dba
What is sql and its types?
