|  |  |  | Library |  | Product |  | Contents |  | Index |

# SQL*Plus Limits

Table C-1, on the following page, lists the limit, or maximum value, of each of the SQL*Plus elements shown. The limits shown are valid for most operating systems.

Item | Limit 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 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

Table C - 1.

Prev Next |  |  |  |  |  |  |  |  | Copyright © 1997 Oracle Corporation. All Rights Reserved. |  |  |  |  |  |  |  | Library |  |  | Product |  |  | Contents |  |  | Index |