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 #