How to Use Data Types?

CHAR - Character data can consist of characters, digit, and special characters. The maximum field size is 240 characters.

DATE Date fields can contain valid dates in the range of January, 1,4712 BC. to December 31, 4711 An. Dates are displayed in the form DD MM YY (for example, 17-OCT-88)

DECIMAL Decimal fields can contain digits 0 through 9 and an optional negative sign. No fractional values may be specified (that is, 245 but not 245.0)

FLOAT - FLOAT data is the same as NUMBER data.

INTEGER INTEGER data is the same as NUMBER data, except only whole numbers can be specified.

LONG - LONG data fields can contain character data up to 65, 532 characters long. Only one LONG column per table is allowed.

LONG RAW - LONG RAW is raw binary data (such as 2's complement binary) Graphics data can be stored in LONG RAW form.

LONG VARCHAR - LONG VARCHAR data is identical to LONG data.

NUMBER - NUMBER data can contain digits 0 through 9 and an optional negative sign. The number of decimal places and the total number of digits can be specified. This total includes digits before and after the decimal place.

RAW -RAW binary data such as bit graphics can be stored in RAW data columns. Oracle does not attempt to interpret RAW (or LONG RAW) data. The maximum field size is 240 characters.

SMALLINT- SMALLINT data is the same as INTEGER data.

VARCHAR- VARCHAR data is the same as CHAR data.

Domain Name Search