How you open and close a cursor variable.Why it is required?

Answer Posted / venkat

open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the importance of .pll extension in oracle?

742


Explain the use of control file?

848


How to run create database statement again?

785


What are the original export and import utilities?

743


What is bulk copy or bcp in oracle?

812






What is the purpose of tables, private synonyms and public synonyms in Oracle?

780


What are ddl statements in oracle?

747


Can the query output be sorted by multiple columns in oracle?

733


What do you mean by group by clause?

749


What are the different types of trigger and explain its various uses and functions?

728


how can we store any pdf file in oracle

1831


What is the relationship among database, tablespace and data file?

729


Write a syntax for update query in oracle?

779


Explain an extent?

829


How to see the table columns used in an index?

768