|
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 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 scripts
|
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
|
