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


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: 64103
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...

Regards
Michel

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

Report message to a moderator

Previous Topic: Is there anything like that?
Next Topic: Difference between 2 database objects
Goto Forum:
  


Current Time: Sun Dec 04 20:32:10 CST 2016

Total time taken to generate the page: 0.08467 seconds