If we dont close the cursor we get error becoz once u open a cursor unless

hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com

Question Posted / jyothi

8 Answers
37179 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / jyothi

If we dont close the cursor we get error becoz once u open a
cursor unless u close it search for another row cannot be
done. A cursor opened should be closed once the result for
that particular search is obtained.

Is This Answer Correct ?

6 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use distinct and count in sql query? Explain

1001

what is the difference between primary key and unique key? : Sql dba

1016

What is a database? Explain

1096

How to call a javascript function from pl sql?

1119

what is the difference between $message and $$message? : Sql dba

982

How to start the command-line sql*plus?

1040

How do you concatenate in sql?

1014

What is interval partition?

1042

What is an index in sql with example?

959

What are properties of the transaction?

991

How do I write a cron which will run a sql query and mail the results to agroup?

961

What are triggers and its types?

1042

What are aggregate functions in sql?

1140

How do I view an execution plan in sql?

968

What are pl/sql cursors?

1037