what are the different types of cursors? explain?

Answer Posted / manish kumar

Implicit cursor is declered by System its own But Explicit
cursor is declered by user

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a syntax for update query in oracle?

613


How to use group functions in the select clause using oracle?

587


What is a trace file and how is it created in oracle?

546


What is enter substitution variable in oracle?

566


What do you mean by a deadlock?

513






How to define a variable of a specific record type?

605


What is oracle rowcount?

568


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1560


Explain the use of full option in exp command.

583


What is the difference between substr & instr functions?

593


Explain what are the different type of segments?

573


Why do we use coalesce function in oracle?

618


Explain what are the advantages of views?

603


How to retrieve data from an cursor to a record?

559


what is meant by magic query

1766