The general SQL*Plus limits shown are valid for most operating systems.
| Item | Limit |
|---|---|
|
filename length |
system dependent |
|
username length |
30 bytes |
|
substitution variable name length |
30 bytes |
|
substitution variable value length |
240 characters |
|
command-line length |
2500 characters |
|
LONG |
2,000,000,000 bytes |
|
LINESIZE |
system dependent |
|
LONGCHUNKSIZE value |
system dependent |
|
output line size |
system dependent |
|
SQL or PL/SQL command- 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 |
32,767 characters |
|
maximum ARRAYSIZE |
5000 rows |
|
maximum number of nested scripts |
20 |
|
maximum page number |
99,999 |
|
maximum PL/SQL error message size |
2K |
|
maximum ACCEPT character string length |
240 Bytes |
|
maximum number of substitution variables |
2048 |