Multivalued attribute
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A multivalued attribute is an attribute whose value is a set of values.
Oracle supports multivalued attributes with the NESTED TABLE and VARRAY datatypes. However, a pure relational design cannot have multivalued attributes. When normalizing, multivalued attributes must be split into separate entities with 1:N relationships between them.
Also see
Glossary of Terms | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |