Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 22965 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 you modify a trigger?
How do you write an index?
i have some prob lem to tell me about my self in interview first round ...
How do I view stored procedures?
Is and as keyword in pl sql?
How many types of literals are available in pl sql?
What is the most common sql injection tool?
what is row? : Sql dba
How do I find duplicates in sql?
What is a sql schema used for?
what is the difference between nested subquery and correlated subquery?
what is data manipulation language? : Sql dba
Can primary key be changed?
What is sql basics?
What is dml and ddl?
