difference between imlicit cursor and explicit cursor ?

Answer Posted / harsha vardhan reddy

implicit: it is generating by sql server.

explicit: it is generating by user.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State and explain the different types of data models?

536


Why do we use coalesce function in oracle?

631


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2395


How do you bind variables in oracle?

547


What is meant by joins? List out the types of joins.

526






How to add another datafile to a tablespace?

577


Why do we need oracle client?

511


How to drop a tablespace?

574


Explain what are the advantages of views?

613


How to assign data of the deleted row to variables?

579


List out the difference between commit, rollback, and savepoint?

619


How can we force the database to use the user specified rollback segment?

559


What is an oracle wallet?

515


How data locks are respected in oracle?

574


How to synchronize 2 schema's objects?

1690