Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
BINARY_DOUBLE | NUMERIC | X | X | X | 64-bit floating point number. This datatype requires 9 bytes, including the length byte. |
BINARY_FLOAT | NUMERIC | X | X | X | 32-bit floating point number. This datatype requires 5 bytes, including the length byte. |
FLOAT | NUMERIC | X | X | X | equal to NUMBER(22,128) |
NUMERIC | NUMERIC | X | 15 | 5 | Numeric Value from 1 X 10 ^-130 |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | Fixed length character string from 1 - 2000 bytes |
NCHAR | CHARACTER | 25 | X | X | Unicode representations of character strings |
NVARCHAR2 | CHARACTER | 25 | X | X | Unicode representations of character strings |
ROWID | CHARACTER | X | X | X | Data type to store the address of a ROW - Physical ID |
UROWID | CHARACTER | X | X | X | Data type to store the address of a Universal ROW - Logical ID |
VARCHAR | CHARACTER | 25 | X | X | Variable length character string from 1 - 4000 bytes |
VARCHAR2 | CHARACTER | 25 | X | X | Variable length character string from 1 - 4000 bytes |
DATE & TIME DATA TYPES | |||||
DATE | TIMESTAMP | January 1, 4712 BC, to December 31, 9999 AD |
X | X | Stored the date and time - day, month, year, hour, minute, seconds - NO FRACTIONAL SECONDS |
TIMESTAMP | TIMESTAMP | X | X | X | Stored the date and time - day, month, year, hour, minute, seconds - NO FRACTIONAL SECONDS |
TIMESTAMPLTZ | TIMESTAMP | X | X | X | Stored the date and time - day, month, year, hour, minute, seconds - NO FRACTIONAL SECONDS |
TIMESTAMPTZ | TIMESTAMP | X | X | X | Stored the date and time - day, month, year, hour, minute, seconds - NO FRACTIONAL SECONDS |
BINARY & LARGE OBJECT DATA TYPES | |||||
BFILE | BINARY | X | X | X | File locator to an external operating system file - 4 Gigs (Read Only Data) |
BLOB | BINARY | X | X | X | Binary Large Object - 4 Gigs |
CLOB | CHARACTER | X | X | X | Character Large Object, up to 4 Gigs of data |
LONG | BINARY | X | X | X | Is for backward compatibility to CLOB and NCLOB - Only 2 Gigs, and only one column per table |
LONG RAW | BINARY | X | X | X | Backward compatibilty to BLOB |
NCLOB | CHARACTER | X | X | X | Unicode rep of CLOB |
RAW | BINARY | 50 | X | X | Variable length data type like VARCHAR - Except it is stored in hexadecimal |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017