Home » SQL & PL/SQL » SQL & PL/SQL » Nested Table,Varray
Nested Table,Varray [message #262857] Tue, 28 August 2007 06:51 Go to next message
Messages: 8
Registered: August 2007
Junior Member
I have doubt. Is there anything which we cant do without Nested Table,Varray stored as database column??

I dont get why these structures required, because they make it so complicated to manupulate individual elements.
Re: Nested Table,Varray [message #262870 is a reply to message #262857] Tue, 28 August 2007 07:10 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use them unless your manager forces you to use it.
You're right, it is more complicated, it is slower, it is difficult to use, quite impossible to optimize unless you use undocumented feature...
After all, Oracle is Relational DBMS not an Object one.
First normal form says each field must be atomic.

Previous Topic: PL/SQL Crosstab
Next Topic: HOw to apply priority on database triggers
Goto Forum:

Current Time: Wed Oct 26 14:45:55 CDT 2016

Total time taken to generate the page: 0.24157 seconds