Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit and explicit trigger
- 2 Answers
- 23077 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 linq to sql?
What is sql partition function?
how to show all tables with 'mysql'? : Sql dba
how is myisam table stored? : Sql dba
What is difference between hql and native sql?
Show code of a cursor for loop.
What is a constraint?
What is difference between sql and mysql?
What is the difference between local variables and global variables?
differentiate between float and double. : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
How to prepare for oracle pl sql certification?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
what does the t-sql command ident_current does? : Transact sql
Explain the uses of control file.
