The following supported datatypes for all the columns in a data source object are represented by icons located in the right hand column of the object in the Query window.
Datatype |
Icon |
Description |
Character |
|
Use the Character datatype for fixed length character data, to a maximum size of 255 bytes and a default size of 1 byte. Note: You can represent numbers using the Character datatype, but you can only perform calculations with numeric datatypes. |
Varchar2 |
|
Use the Varchar2 datatype for variable length character strings, to a maximum size of 2000 bytes. You must specify a size for the Varchar2 datatype. |
Number |
|
Use the Number datatype for integer or floating data. You must enter a precision length (number of digits) for integer data. Floating datatype is for decimal numbers. When you assign this datatype to a column, you must specify both the precision and the scale. The precision (total number of digits in the number) can range from 1 to 38. The scale (number of digits to the right of the decimal point) can range from -84 to 127. 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 10 digits with 2 to the right of the decimal point. A specification of (10,-2) effectively means a 10-digit integer, rounded to the nearest hundred. |
Date |
|
Use the Date datatype for any type of date. Valid dates range from January 1, 4712 BC to December 31,4712 AD. The default date format is DD-MON-YY, as in ‘01-JAN-97.’ |
Long |
|
Use the Long datatype for long text fields of alphanumeric data of variable length, up to 2 gigabytes. |
Raw |
|
Use the Raw datatype for raw binary data. The maximum size is 255 bytes. Values must be inserted as character strings in hexadecimal notation, and values are displayed in hexadecimal. You must specify a size for raw data. |
Long Raw |
|
The Long Raw datatype is for storing up to 2 gigabytes of raw binary data (which is entered and displayed in hexidecimal form). Long Raw datatypes do not require a specified size. |
MLSLABEL |
|
Use the MLSLABEL datatype for storing the binary format of a label used on a secure operating system. Labels are used by Trusted ORACLE to mediate access to information. You can also define columns with this datatype if you are using the standard ORACLE Server. For more information on Trusted ORACLE, including this datatype and labels, see the Trusted Oracle9i Server Administrator's Guide. |
Data source object notation in the Query window (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.