using nested tables

pcdunham · #1 (**permalink**) 07-08-03, 20:01

Could someone give an example of when a nested table, or varray would be applicable? I have restrained from using them mainly because I don't think there is any way to use them with cmp entity beans. Is there a way to use them with cmp entity beans? The only situation I can think of is if there was say a user with a corresponding table that contained a nested table for something like user propeties. It seems that collection types are more for speed and organization than normalization.
Thanks,
Philip

andrewst · #2 (**permalink**) 07-09-03, 07:10

Quote:

Originally posted by pcdunham
Could someone give an example of when a nested table, or varray would be applicable? I have restrained from using them mainly because I don't think there is any way to use them with cmp entity beans. Is there a way to use them with cmp entity beans? The only situation I can think of is if there was say a user with a corresponding table that contained a nested table for something like user propeties. It seems that collection types are more for speed and organization than normalization.
Thanks,
Philip

They are a violation of 1st normal form but appeal to OO programmers who don't appreciate the value of normalisation.