Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql
pl/sql [message #252281] Wed, 18 July 2007 08:25 Go to next message
Messages: 98
Registered: July 2007
Hi all

can u please tell me what can actually a programmer use cursors ,loops, records and index by tables for ? i wanna know their use individually if any for a programmer as he needs to handle large amount of data.

in index by tables if we are using conditions like if..... then even if in cursors we are using if..... then to mention some conditions is it necessary that they should be written inside the loops?

for example if in departments table with ids 1 to 10 i dont want 5 and 7 and i give count to others like if v_count=1 then v_deptid=10
then are these if ....then conditions are to be written in the loop?? please let me know.

Re: pl/sql [message #252296 is a reply to message #252281] Wed, 18 July 2007 09:05 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Previous Topic: acquired nowait
Next Topic: deleting records in a table based on a collection
Goto Forum:

Current Time: Tue Aug 22 21:34:14 CDT 2017

Total time taken to generate the page: 0.06540 seconds