Flashcards in Data Types Deck (9)
Fixed-length character data, 1 to 255 characters
Variable-length character data, 1 to 2,000 characters. VARCHAR is automatically converted to VARCHAR2 in Oracle.
Numeric data. NUMBER(9,2) is used to specify numbers that have two decimal places and are up to nine digits long, including the decimal places. Some RDBMSs permit the use of a MONEY or a CURRENCY data type.
Numeric data. DBMSs that do not support the NUMBER data type typically use NUMERIC instead.
Integer values only. INT is automatically converted to NUMBER in Oracle.
Small integer values only. SMALLINT is automatically converted to NUMBER in Oracle.