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

What is the sid in oracle?

968

Can we store images in oracle database?

1010

Explain the use of show option in imp command.

1098

How can you merge two tables in oracle?

1001

What privilege is needed for a user to create indexes in oracle?

1028

What is oracle instant client?

1024

How can Oracle users be audited?

1118

How to convert a date to char in oracle? Give one example.

1069

What is the difference between 10g OEM and 11g OEM?

965

How to filter out duplications in the returning rows using oracle?

1018

What is SQL access advisor in Oracle?

1193

Is truncate autocommit in oracle?

1087

How to start your 10g xe server from command line?

1073

Explain the use of analyse option in exp command.

1128

How to use attributes of the implicit cursor in oracle?

1011