State the difference between implict and explict cursor's?
Answer Posted / bhavesh shah
Implicit cursor:- It always return one row, and no loop is
used in.
Explicit cursor:- It returns more than one row and here loop
is used.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What are stored procedures used for?
Can we create foreign key without primary key?
What are the two different parts of the pl/sql packages?
Why use truncate instead of delete?
What is prepared statement in sql?
Which data dictionary views have the information on the triggers that are available in the database?
How to assign sql query results to pl sql variables?
What is sql data?
How do I remove sql developer from windows 10?
How to select unique records from a table?
What is a database event trigger?
Define concurrency control. : Transact sql
Can we use the cursor's to create the collection in PL/SQL?
What is the requirement of self-join?
Can we insert data in view?