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 usage of control file in oracle?

1084

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

What do you understand by database schema and what does it hold?

1230

What do you know about normalization? Explain in detail?

951

How to use subqueries with the in operator using oracle?

1091

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

1044

What is MTTR advisor in Oracle?

1090

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

1188

How to use an explicit cursor without open statements?

1055

What is a data dictionary and how can it be created?

1146

What is a trigger and what are its types in oracle?

1070

How to list all user accounts in oracle?

1027

How to pass parameters to procedures?

1032

what are the advantages of running a database in archive log mode?

2203

What are the differences between interval year to month and interval day to second?

1026