User`s guide

SQL*Plus 3-1

SQL*Plus

SQL*Plus is a general purpose utility used for running SQL commands and PL/SQL

blocks, perform database administration, and so on. This chapter describes how you

use SQL*Plus under BS2000/OSD. It supplements the SQL*Plus User's Guide and

Reference with information about the following topics:

■ Running SQL*Plus

■ Specifying the Search Path for SQL*Plus Command Files

■ Sample Schemas and SQL*Plus

■ SQL*Plus Limits

■ Using SQL*Plus in the POSIX environment

3.1 Running SQL*Plus

The following sections describe how to run SQL*Plus under BS2000/OSD:

■ SQL*Plus User Profiles

■ Starting SQL*Plus

■ Interrupting SQL*Plus

■ Issuing BS2000 Commands from SQL*Plus

■ Starting the BS2000 Editor

■ The SQL ASCII Function

■ Spooling SQL*Plus Output

■ Using SQL*Plus Symbols

For restrictions related to using SQL*Plus, refer to the section, Known Problems,

Restrictions, and Workarounds in Oracle Database Installation and Administration Guide

for Fujitsu BS2000/OSD.

3.1.1 SQL*Plus User Profiles

There are two startup files for SQL*Plus:

■

GLOGIN.SQL

, which is the global startup file

■

, which is designed for local and individual use

Whenever any user starts SQL*Plus, first the

GLOGIN.SQL

file is read, followed by the

user's

file.