There are limitations to SQL that is different than the Oracle database, as follows:
Table B-1 Datatype Limits
Datatypes | Limit | Comments |
---|---|---|
BFILE | Maximum size: 2 GB
Maximum size of the directory or file names: no database imposed limit |
All BFILE objects are stored as LOB |
BLOB | Maximum size: 2 GB |
|
CHAR | Maximum size: 4096 bytes |
|
CHAR VARYING | Maximum size: 4096 bytes |
|
CLOB | Maximum size: 2 GB |
|
Literals | No limit |
|
LONG | Maximum size: 2 GB | A table can have any number of long columns |
NUMBER | Operating system limit | NUMBER is converted to a double precision number on the native platform |
NUMBER (p, s) | 999 ... (38 9's) x 10 ^ 125 maximum
-999... (38 9's) x 10 ^125 minimum |
Maximum precision of 38 decimal digits |
VARCHAR | Maximum size: 4096 bytes |
|
VARCHAR2 | Maximum size: 4096 bytes |
|
Table B-2 Physical Database Limits
Item | Limit | Comments |
---|---|---|
Database Block Size | 4096 bytes | Fixed size |
Database File | 1 database file for each catalog | An application can open any number of catalogs. |
Database File Size | 4 GB | Affected by the operating system. Maximum file size allowed by the operating system. |
Max Object or Row Length | 4040 | When an object (row) exceeds this length, it is converted into a binary long object. So, UNION will not work on this table. |
DSN Name | 31 bytes (31 US chars) | Limit is 31 bytes |
Database Path Name | 129 bytes | _MAX_PATH -5, which is 255 on Win32 |
Database filename | 129 bytes | _MAX_PATH -8, which is 252 on Win32. |
Table B-3 Logical Database Limits
Item | Limit | Comments |
---|---|---|
Indexes | Maximum for each table | unlimited |
Columns | table | 1000 |
|
index | 32 columns maximum |
Constraints | Maximum for each column | unlimited |
Nested queries | Maximum number | unlimited |
Rows | Maximum number for the table | no limit |
SQL statement length | Maximum length of statements | unlimited, particular tools may impose lower limits |