State the difference between implict and explict cursor's?
Answer Posted / l..l.n.reddy
IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.
EXPLICT CURSOR:- Defined by user. queries returns more
than rows.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
what is meant by urlencode and urldocode? : Sql dba
explain the options of myisamchk to improve the performance of a table. : Sql dba
Show code of a cursor for loop.
what are the performance and scalability characteristics of mysql? : Sql dba
what are the types of join and explain each? : Sql dba
Is sqlexception checked or unchecked?
How to prepare for oracle pl sql certification?
Which table is left in join?
What is dense_rank?
What is sql query optimization?
What does the argument [or replace] do?
what is schema? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is function and procedure in pl sql?