|
|
Re: difference between collection & pl/sql library [message #298144 is a reply to message #298131] |
Tue, 05 February 2008 02:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
mshrkshl
Messages: 247 Registered: September 2006 Location: New Delhi
|
Senior Member |
|
|
PL/SQL collection types let you declare high-level datatypes similar to arrays, sets, and hash tables found in other languages. In PL/SQL, array types are known as varrays (short for variable-size arrays), set types are known as nested tables, and hash table types are known as associative arrays. Each kind of collection is an ordered group of elements, all of the same type. Each element has a unique subscript that determines its position in the collection. When declaring collections, you use a TYPE definition.
where pl/sql library has built in functions and procedures with conversion,drag and drop,form builder,oracle applications objects,window system interface etc.utilities.
regards,
|
|
|