filename length

system dependent

username length

128 bytes

substitution variable name length

128 bytes

substitution variable value length

240 characters

command-line length

5000 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