what is the difference between implicit and explicit trigger
- 2 Answers
- 21450 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
How do we accept inputs from user during runtime?
How much does sqlite cost?
What is the use of <> sql?
what is csv? : Sql dba
Explain exception handling in pl/sql?
Why do we use triggers?
Can we insert in sql function?
Explain what is a column in a table?
What can you do with pl sql?
How does a covering index work?
When you have to use a default "rollback to" savepoint of plvlog?
What is difference between group by and partition by?
What is difference between stored function and application function?
What do you know by pl/sql cursors?
What is difference between inner join and cross join?
