open cursor then the cursor points to the starting of the data......close t

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

Question Posted / venkat

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

Please Help Members By Posting Answers For Below Questions

How to install oracle database 10g xe?

964

How to create lov dynamically at runtime & attach to text field?

1097

Explain implicit cursor.

960

Â How to use an oracle sequence generator in a mapping?

1017

what is Single Byte Overhead...?

2498

Explain the dml?

918

Are truncate and delete commands same? If so why?

1079

What is a subquery in oracle?

1040

What is the usage of save points in oracle database?

907

What is the best way to do multi-row insert in oracle?

1012

How to count duplicated values in a column in oracle?

982

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4479

When do you get a .pll extension in oracle?

1077

Explain what does a control file contain?

1032

Can we create database in oracle using command line ?

1028