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
829
|
| Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
| NUMERIC DATA TYPES | |||||
| 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 |
| 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 |
| 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 |
| DATE & TIME DATA TYPES | |||||
| DATE | DATETIME | X | 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 | BLOB | 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 | CHARACTER | 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