Multivalued attribute

From Oracle FAQ
Jump to: navigation, search

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.

[edit] 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 #