Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 22938 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
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
what is csv? : Sql dba
Give the order of sql select?
What are the advantages of indexing?
Why partition by is used in sql?
What does trigger mean in psychology?
Is sql considered coding?
what is meant by urlencode and urldocode? : Sql dba
what is the difference between where clause and having clause? : Sql dba
What is oracle pl sql developer?
What is cte?
What is the difference between clustered and non-clustered index in sql?
Can you inner join the same table?
Is grant a ddl statement?
what is union, minus and interact commands? : Sql dba
