SQL*Plus Settings You Can Control

The specific customizations you can make may vary depending on the operating system and the SQL*Plus version. Generally, though, you need to be aware of the login scripts and the environment variable settings.

Two SQL scripts are executed whenever SQL*Plus starts up:

Site profile

The first script, known as the site profile, is named glogin.sql . It applies globally to all users on a particular computer.

User profile

The second script, known as the user profile (not the same thing as the product user profile discussed in Chapter 13), is named login.sql . Each user may have his or her own user profile script.

The most obvious use for these files is to execute SET commands to customize the environment settings to something other than their defaults.

Several operating system environment variables affect how SQL*Plus operates. Some of what these environment variables allow you to specify include:


The search path to use for SQL scripts


A default database connection


The language being used

Under Windows, these settings can be made in the registry, but environment variables take precedence over their corresponding registry settings.


Introduction to SQL*Plus

Command-Line SQL*Plus

Browser-Based SQL*Plus

A Lightning SQL Tutorial

Generating Reports with SQL*Plus

Creating HTML Reports

Advanced Reports

Writing SQL*Plus Scripts

Extracting and Loading Data

Exploring Your Database

Advanced Scripting

Tuning and Timing

The Product User Profile

Customizing Your SQL*Plus Environment

Appendix A. SQL*Plus Command Reference

Appendix B. SQL*Plus Format Elements

Oracle SQL Plus The Definitive Guide, 2nd Edition
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net