|
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 |
system dependent |
|
output line size |
system dependent |
|
line size after variable
substitution |
3,000 characters (internal only) |
|
number of characters in a COPMUTE 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 |
|
maximum ACCEPT
character string length |
240 Bytes |
|
maximum number of DEFINE variables |
2048 |
