For example, number(7,2) is a number that has 5 digits before the decimal and 2 digits after the decimal.

For example, numeric(7,2) is a number that has 5 digits before the decimal and 2 digits after the decimal.

For example, dec(3,1) is a number that has 2 digits before the decimal and 1 digit after the decimal.

For example, decimal(3,1) is a number that has 2 digits before the decimal and 1 digit after the decimal.

Includes year, month, day, hour, minute, and seconds.

For example:
timestamp(6)

Includes year, month, day, hour, minute, and seconds; with a time zone displacement value.

For example:
timestamp(5) with time zone

For example:
timestamp(4) with local time zone

For example:
interval year(4) to month

fractional seconds precision must be a number between 0 and 9. (default is 6)

fractional seconds precision must be a number between 0 and 9. (default is 6)

fractional seconds precision must be a number between 0 and 9. (default is 6)

For example:
interval day(2) to second(6)

Where BBBBBBB is the block in the database file;
RRRR is the row in the block;
FFFFF is the database file.

Where BBBBBBB is the block in the database file;
RRRR is the row in the block;
FFFFF is the database file.

Where BBBBBBB is the block in the database file;
RRRR is the row in the block;
FFFFF is the database file.

Where size is optional.