what is the difference between implicit and explicit trigger
- 2 Answers
- 21410 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
Explain table and field in sql?
What is nosql example?
How do I view a table in sql?
Which sql statement is used to return only different values?
Why do we use procedures in pl sql?
What are the advantages of sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is user defined functions?
Is sql better than access?
How does a self join work?
Which data dictionary views have the information on the triggers that are available in the database?
What is user in sql?
What are sql commands?
How do I view a view in sql?
