Specifies exactly precision digits of precision (max 38)Įxample: Numeric(10,3) holds numbers accurately in the following format: ppppppp.sss Stores data of variable indeterminate size, some functionality not available for blobs of 4GB and larger, maximum size depends on page size (less than 4GB for page size 4096, more than 128GB for page size 16384) Number of fractions (100 microseconds) since midnight, and offset or timezone id as 16-bit structure (and 16-bit padding)
Number of fractions (100 microseconds) since midnightĠ:00 to 23:59.9999 with offset in minutes Includes time and data as two 32-bit structures, and offset or timezone id as 16-bit structure (and 16-bit padding) Includes time and date as two 32-bit structures NB, multi-byte character sets reduce number of possible characters proportionately. NB, multi-byte character sets reduce number of possible characters proportionately.įixed length char or text string, padded with spaces.
Depends on the database page size and index types (single-segment or compound). NOTE: 8-byte ID is stored for each BLOB or ARRAY reference size of BLOB or ARRAY data is not counted in row size.Ī few hundreds. (Example: 16,384 INTEGER (4-byte) values per row.) NOTE: Page size (PAGE_SIZE) can be 4096, 8192, 16384 or 32768.ĭepends on data types used.
