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: 63945
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: SQL
Next Topic: Grant - All objects in a schema to a new user
Goto Forum:

Current Time: Fri Oct 28 07:52:11 CDT 2016

Total time taken to generate the page: 0.08622 seconds