Home » SQL & PL/SQL » SQL & PL/SQL » collections
icon5.gif  collections [message #244580] Wed, 13 June 2007 07:37 Go to next message
Messages: 123
Registered: February 2007
Senior Member

In real time at wht sitaution we will go for nested tables,varrays,index-by table?
Re: collections [message #244620 is a reply to message #244580] Wed, 13 June 2007 09:16 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Permanently stored in tables (for nested table and varrays, it is not possible for index-by). No real use, just a performances killer.
For PL/SQL treatments many and many. For instance, for bulk operations, pipelined functions...


[Updated on: Wed, 13 June 2007 09:17]

Report message to a moderator

Previous Topic: Difference between 2 database objects
Next Topic: Issue with a query
Goto Forum:

Current Time: Sun Aug 20 19:56:30 CDT 2017

Total time taken to generate the page: 0.01244 seconds