ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Ahmed Mohamed , Advanced training (diploma) in oracle EBS 11g . , Arab Academy for science and technology
تاريخ النشر: 2016/03/24
Ali Nawashy
من قبل Ali Nawashy , Medical representative , Al-Hilal Drug Store

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

Gayasuddin Mohammed
من قبل 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.

المزيد من الأسئلة المماثلة