A script-enabled browser is required for this page to function properly.

About Query Builder datatypes

The most common datatypes are:

CHAR or VARCHAR2

CHAR is used for fixed length character data, to a maximum size of 255 bytes and a default size of 1 byte. VARCHAR2 is for variable length character strings to a maximum size of 2000 bytes. You must specify size for VARCHAR2.

NUMBER

NUMBER indicates that the database column contains numbers (integers, decimals, or any other type of numeric values). You can perform calculations on numbers represented in the NUMBER datatype, but not on numbers represented by the CHAR datatype.

DATE

DATE indicates that the database column contains date values. Valid dates ranging from January 1, 9999 BC to December 31, 9999 AD. Default format is DD-MON-YY as in '01-JAN-92'.

NUMBER(p,s)

The range of p (decimal precision) is 1 to 38. The range of s (scale) is -84 to 127. Decimal precision is the number of digits to store. The scale is the number of digits to the right of the decimal point. If the scale is negative, the actual data is rounded to the specified number of places to the left of the decimal point. For example, a specification of (10, -2) means round to the hundreds.

Additionally, Query Builder provides limited support for the following Oracle datatypes:

LONG

A LONG column contains alphanumeric data of variable length up to 2 gigabytes (or 231-1). When you include a LONG column in a Query Builder query, the first 2000 characters are displayed.

RAW

Raw binary data. Maximum size is 255 bytes. Values must be inserted as character strings in hexadecimal notation. Values are displayed in hexadecimal. You must specify size for RAW datatypes.

LONG RAW

LONG RAW displays raw binary data up to 2 gigabytes (this appears in hexadecimal in the Results window). LONG RAW datatypes are subject to the same limits as RAW datatype.

Note: Query Builder supports datatype conversions in cases where conditions and expressions reference different datatypes in their comparison. Refer to the Oracle9i Server SQL Language Reference Manual for additional information.

See also

Datatype icons (Query Builder)