| pl/sql [message #252281] |
Wed, 18 July 2007 08:25  |
avrillavinge
Messages: 98
Registered: July 2007
|
Member |
|
|
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
