Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

The Site and User Profiles

Two script files are executed every time SQL*Plus is started. These scripts define the site profile and the user profile, and are named, respectively, glogin.sql and login.sql.

The Site Profile

The site profile is made up of the commands contained in glogin.sql, which is the global login file, and is automatically executed every time a user runs SQL*Plus on a given computer system. The location of glogin.sql varies from one operating system to the next, but it is always below the directory containing the SQL*Plus product. On a default Windows 95 installation of Oracle8, glogin.sql may be found in the following directory:

C:\ORAWIN95\PLUS80

On a typical Unix system, such as the HP-9000, the glogin.sql file will be found in this directory:

$ORACLE_HOME/sqlplus/admin

The specific version of SQL*Plus you are running makes a difference as well. If you have multiple versions of SQL*Plus installed, the default installation procedures will result in your having a separate glogin.sql file for each. For example, a Windows 95 PC running both SQL*Plus 8.0 and SQL*Plus 3.3 will have a glogin.sql file in each of the following two directories:

C:\ORAWIN95\PLUS80
C:\ORAWIN95\PLUS33

The specific file that is executed will depend on which version of SQL*Plus you are running.

Tip

On Windows 95/NT, the PLUSXX registry setting, where XX refers to the specific SQL*Plus version, points to the location of glogin.sql. By pointing the PLUS80 and PLUS33 registry settings to the same directory, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata