There are limitations to SQL that is different than the Oracle database, as follows:
| 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 |