tutorial

2 SQL*PlusIntroductionSQL*Plus is the interactive (low-level) user interface to the Oracle database managementsystem. Typically, SQL*Plus is used to issue ad-hoc queries and to view the query result onthe screen. Some of the features of SQL*Plus are:• A built-in command line editor can be used to edit (incorrect) SQL queries. Instead ofthis line editor any editor installed on the computer can be invoked.• There are numerous commands to format the output of a query.• SQL*Plus provides an online-help.• Query results can be stored in files which then can be printed.Queries that are frequently issued can be saved to a file and invoked later. Queries can beparameterized such that it is possible to invoke a saved query with a parameter.A Minimal User GuideBefore you start SQL*Plus make sure that the following UNIX shell variables are properly set(shell variables can be checked using the env command, e.g., env | grep ORACLE):• ORACLE HOME, e.g., ORACLE HOME=/usr/pkg/oracle/734• SID, e.g, SID=prodIn order to invoke SQL*Plus from a UNIX shell, the command sqlplus has to be issued.SQL*Plus then displays some information about the product, and prompts you for your username and password for the Oracle system.gertz(catbert)54: sqlplusSQL*Plus: Release 3.3.4.0.1 - Production on Sun Dec 20 19:16:52 1998Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.Enter user-name: scott password:Connected to:Oracle7 Server Release 7.3.4.0.1 - Production ...