| Item
| Limit
|
| filename length
| system dependent
|
| username length
| 30 bytes
|
| user variable name length
| 30 bytes
|
| user variable value length
| 240 characters
|
| command-line length
| 2500 characters
|
| length of a LONG value entered through SQL*Plus
| LINESIZE value
|
| LINESIZE
| system dependent
|
| LONGCHUNKSIZE value (requires Oracle7)
| MAXDATA value
|
| MAXDATA value
| system dependent
|
| output line size
| system dependent
|
| line size after variable substitution
| 3,000 characters (internal only)
|
| number of characters in a COMPUTE command label
| 500 characters
|
| number of lines per SQL command
| 500 (assuming 80 characters per line)
|
| maximum PAGESIZE
| 50,000 lines
|
| total row width
| 60,000 characters for VMS; otherwise, 32,767 characters
|
| maximum ARRAYSIZE
| 5000 rows
|
| maximum number of nested command files
| 20 for VMS, CMS, Unix; otherwise, 5
|
| maximum page number
| 99,999
|
| maximum PL/SQL error message size
| 2K (Oracle7)
512 Bytes (Oracle Version 6)
|
| maximum ACCEPT character string length
| 240 Bytes
|
