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: 64629
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: Thu Mar 30 19:40:53 CDT 2017

Total time taken to generate the page: 0.12373 seconds