User`s guide

Using SQL*Plus in the POSIX environment
SQL*Plus 3-5
SQL> START filename
If this file cannot be found, then SQL*Plus searches the paths specified by the ORAENV
environment variable
SQLPATH . This variable is used to specify one or more file name
prefixes separated by a semicolon (;), which should be applied when searching for the
command file.
For example, if SQLPATH is set to PRIVATE and $GLOBAL , as follows:
SQLPATH=PRIVATE;$GLOBAL
then, when you enter the following command:
@filename
SQL*Plus searches for the command file in the following sequence, until a matching
file name is found:
1. filename.SQL
2. PRIVATE.filename.SQL
3. $GLOBAL.filename.SQL
Refer to Chapter 1, "Getting Started" for more information about default file name
extensions.
3.3 Sample Schemas and SQL*Plus
The sample schemas provide a common platform for examples. For more information
about the sample schemas and SQL*Plus, Refer to SQL*Plus User's Guide and Reference.
Refer to the chapter "Creating and Upgrading a Database" in Oracle Database
Installation and Administration Guide for Fujitsu BS2000/OSD for information about how
to install the sample schemas.
3.4 SQL*Plus Limits
The limits of several SQL*Plus elements are specified in the SQL*Plus User's Guide and
Reference. The following table defines BS2000/OSD specific limits:
3.5 Using SQL*Plus in the POSIX environment
Starting with Oracle Database 11g Release 2 on Fujitsu BS2000/OSD you can run
SQL*Plus not only in the normal BS2000 environment, but also in the POSIX
environment.
This section describes the following:
■ Starting SQL*Plus
Item Limit
File name length 54 (including catalog-id and user ID)
LINESIZE 32767
MAXDATA 32767
Maximum number of
nested command files
12