<<enumeration>> PrimitiveType {Analysis}

Documentation
4.1 Data types

A data type is a set of representable values. Every representable value belongs to at least one data type and some belong to several data types. [...]

Every predefined data type is a subtype of itself and of no other data types. It follows that every predefined data type is a supertype of itself and of no other data types. The predefined data types are individually described in each of Subclause 4.2, "Character strings", through Subclause 4.6, "Datetimes and intervals". Row types, reference types and collection types are described in Subclause 4.8, "Row types", Subclause 4.9, "Reference types", Subclause 4.10, "Collection types", respectively.

SQL defines predefined data types named by the following <key word> s: CHARACTER , CHARACTER VARYING , CHARACTER LARGE OBJECT , BINARY LARGE OBJECT , NUMERIC , DECIMAL , SMALLINT , INTEGER , BIGINT , FLOAT , REAL , DOUBLE PRECISION , BOOLEAN , DATE , TIME , TIMESTAMP , and INTERVAL . These names are used in the type designators that constitute the type precedence lists specified in Subclause 9.5, "Type precedence list determination".


Parent PackageDataTypesAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Attributes
NameClassTypeInitial Value
CHARACTERPrimitiveType  
CHARACTER_VARYINGPrimitiveType  
CHARACTER_LARGE_OBJECTPrimitiveType  
NATIONAL_CHARACTERPrimitiveType  
NATIONAL_CHARACTER_VARYINGPrimitiveType  
NATIONAL_CHARACTER_LARGE_OBJECTPrimitiveType  
BINARYPrimitiveType  
BINARY_VARYINGPrimitiveType  
BINARY_LARGE_OBJECTPrimitiveType  
NUMERICPrimitiveType  
DECIMALPrimitiveType  
SMALLINTPrimitiveType  
INTEGERPrimitiveType  
BIGINTPrimitiveType  
FLOATPrimitiveType  
REALPrimitiveType  
DOUBLE_PRECISIONPrimitiveType  
BOOLEANPrimitiveType  
DATEPrimitiveType  
TIMEPrimitiveType  
TIMESTAMPPrimitiveType  
INTERVALPrimitiveType  
DATALINKPrimitiveType  
XML_TYPEPrimitiveType