Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

In oracle developer how can you break cursor after pointering in your query ?

user-image
Question ajoutée par Ahmed Mohamed , Advanced training (diploma) in oracle EBS 11g . , Arab Academy for science and technology
Date de publication: 2016/03/24
Ali Nawashy
par Ali Nawashy , Medical representative , Al-Hilal Drug Store

you can Close the cursor. for example : CLOSE employees_cur;

Gayasuddin Mohammed
par Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

Thanks for the invitation. Its been long time I was into the industry, so totally out of touch. But let me try to answer what ever I can try to recollect as it is my interests.

once you fetched the data into your CURSOR, you might wanna store the data into RECORD TYPE array structure to make use it in local purpose within a LOOP.

once you done the above you can CLOSE THE CURSOR, if in between the loop i think you can BREAK.

Not very sure as I already mentioned its been 15 years now that I was worked on ORACLE and now totally out of touch.

Any ways I request you to throw some light on it so that I can refresh as well. Thanks.

More Questions Like This