Home » Other » Training & Certification » difference between collection & pl/sql library (0racle 9i)
difference between collection & pl/sql library [message #298131] Tue, 05 February 2008 01:49 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
hello all

what is the difference between collection & pl/sql library ?

can any body help me to make it clear ?

waiting for your reply
Re: difference between collection & pl/sql library [message #298138 is a reply to message #298131] Tue, 05 February 2008 02:15 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Where did you hear/read about these things?
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
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,
Previous Topic: RAC Learning
Next Topic: After passing the OCA exam !!!
Goto Forum:
  


Current Time: Tue Apr 23 06:50:11 CDT 2024