Maximum Length of Command Line Argument
The maximum length of a command line argument is determined by the operating system. In Linux, the maximum length is typically 131,072 bytes (or 128 KB). This includes the length of the SQL*Plus command, SQL query, and any additional parameters.
SQL*Plus Command Line Argument Limits
|
Item |
Limit |
|---|---|
|
filename length |
system dependent |
|
username length |
128 bytes |
|
substitution variable name length |
128 bytes |
|
substitution variable value length |
240 bytes |
|
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 |
SQL*Plus Command Reference
SQL*Plus is a command-line tool for Oracle Database that allows users to interact with the database using SQL and PL/SQL commands.
Here, we will discuss the SQL*Plus commands, and understand how to use the SQL*Plus command-line argument.