SQL*Plus User's Guide and Reference
Release 9.0.1

Part Number A88827-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

C
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.

Table 0-1 SQL*Plus Limits
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 

maximum number of DEFINE variables 

2048 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback