Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 23381 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / madhuri
The implicit cursor is used to process INSERT, UPDATE,
DELETE, and SELECT INTO statements. During the processing of
an implicit cursor,Oracle automatically performs the OPEN,
FETCH, and CLOSE operations.
Where as in explicit cursors,the process of its working is
done in 4 steps namely DECLARE a cursor,OPEN a cursor,
FETCH from cursor and CLOSE a cursor.
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
Which language is used in sql?
What is execute immediate?
Why we use join in sql?
What is optimistic concurrency control? : Transact sql
Can there be more than one function with a similar name in a pl/sql block?
what is meant by nl2br()? : Sql dba
What is the reports view in oracle sql developer?
What is sql scripting?
How to assign sql query results to pl sql variables?
How to take user input in pl sql?
what does the t-sql command ident_incr does? : Transact sql
Which are sql * plus commands?
what is 'mysqlshow'? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How can one get sql*loader to commit only at the end of the load file? : aql loader
