Hierarchy
The image was produced with graphviz/dot and this file.
Predefined types
The standard lists the following predefined types:
- Binary string
- Boolean
- Character string
- Datetime
- Interval (used to store durations/periods of time)
- Numeric
- XML
Composite types
The constructed (composite) data types can be created with one of the constructors
-
ARRAY -
MULTISET -
REF -
ROW
Arrays and Multisets are also referred to as collecion types.
User defined types
A user defined type is a schema object.