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

What is a nvl function?

557


What is merge in oracle?

552


What is save point in oracle database?

721


What is translate in oracle?

615


How to convert character types to numeric types?

568






Why do you use stored procedures and state some of its disadvantages?

558


How to select all columns of all rows from a table in oracle?

586


Explain the use of grant option in exp command.

577


How to get execution path reports on query statements?

552


How do I connect to oracle?

557


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1897


Explain about achiever in sql?

577


Explain how you would restore a database using RMAN to Point in Time?

1623


What is the relation of a user account and a schema in oracle?

577


How to use like conditions in oracle?

564