资料整理——SQLPLUS Reference Guide 11.2 (SQLPLUS参考手册)目录

这几天，利用空闲时间，将通读了一遍。现将目录整理如下：

参考资料：

SQL*Plus® User's Guide and Reference

https://docs.oracle.com/cd/E11882_01/server.112/e16604/toc.htm

SQLPLUS Reference Guide 11.2 TOC Items

Contents

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

What’s New in SQL*Plus?

New Features in SQL*Plus Release 11.2

SQL*Plus Quick Start

SQL*Plus Resources

SQL*Plus Overview

SQL*Plus Prerequisites

Starting SQL*Plus Command-line

Starting SQL*Plus Instant Client

Connecting to a Different Database

Sample Schemas and SQL*Plus

Running your first Query

Exiting SQL*Plus

Part I SQL*Plus Getting Started

1 SQL*Plus User Interface

The Command-line Screen

Changing the Command-line Font and Font Size

2 Configuring SQL*Plus

SQL*Plus Environment Variables

SQLPATH Registry Entry

SQL*Plus Configuration

Site Profile

User Profile

Storing and Restoring SQL*Plus System Variables

Installing Command-line Help

Configuring Oracle Net Services

3 Starting SQL*Plus

Login Username and Password

Secure External Password Store

Expired Password

Changing your Password

Connecting to a Database

Net Service Name

Full Connection Identifier

Easy Connection Identifier

Connectionless Session with /NOLOG

Starting SQL*Plus

Starting Command-line SQL*Plus

Getting Command-line Help

Exiting SQL*Plus Command-line

SQLPLUS Program Syntax

Options

Logon

Start

Part II Using SQL*Plus

4 SQL*Plus Basics

Entering and Executing Commands

The SQL Buffer

Executing Commands

Listing a Table Definition

Listing PL/SQL Definitions

Running SQL Commands

Understanding SQL Command Syntax

Running PL/SQL Blocks

Creating Stored Procedures

Running SQL*Plus Commands

Understanding SQL*Plus Command Syntax

System Variables that Affect How Commands Run

Stopping a Command while it is Running

Running Operating System Commands

Pausing the Display

Saving Changes to the Database Automatically

Interpreting Error Messages

5 Using Scripts in SQL*Plus

Editing Scripts

Writing Scripts with a System Editor

Editing Scripts in SQL*Plus Command-Line

Listing the Buffer Contents

Editing the Current Line

Appending Text to a Line

Adding a New Line

Deleting Lines

Placing Comments in Scripts

Using the REMARK Command

Using /*

Using --

Notes on Placing Comments

Running Scripts

Running a Script as You Start SQL*Plus

Nesting Scripts

Exiting from a Script with a Return Code

Defining Substitution Variables

Using Predefined Variables

Using Substitution Variables

Where and How to Use Substitution Variables

Avoiding Unnecessary Prompts for Values

Restrictions

System Variables

Passing Parameters through the START Command

Communicating with the User

Receiving a Substitution Variable Value

Customizing Prompts for Substitution Variable

Sending a Message and Accepting Return as Input

Clearing the Screen

Using Bind Variables

Creating Bind Variables

Referencing Bind Variables

Displaying Bind Variables

Using REFCURSOR Bind Variables

6 Formatting SQL*Plus Reports

Formatting Columns

Changing Column Headings

Formatting NUMBER Columns

Formatting Datatypes

Copying Column Display Attributes

Listing and Resetting Column Display Attributes

Suppressing and Restoring Column Display Attributes

Printing a Line of Characters after Wrapped Column Values

Clarifying Your Report with Spacing and Summary Lines

Suppressing Duplicate Values in Break Columns

Inserting Space when a Break Column's Value Changes

Inserting Space after Every Row

Using Multiple Spacing Techniques

Listing and Removing Break Definitions

Computing Summary Lines when a Break Column's Value Changes

Computing Summary Lines at the End of the Report

Computing Multiple Summary Values and Lines

Listing and Removing COMPUTE Definitions

Defining Page and Report Titles and Dimensions

Setting the Top and Bottom Titles and Headers and Footers

Displaying System-Maintained Values in Titles

Listing, Suppressing, and Restoring Page Title Definitions

Displaying Column Values in Titles

Displaying the Current Date in Titles

Setting Page Dimensions

Storing and Printing Query Results

Creating a Flat File

Sending Results to a File

Sending Results to a Printer

7 Generating HTML Reports from SQL*Plus

Creating Reports using Command-line SQL*Plus

Creating Reports

Suppressing the Display of SQL*Plus Commands in Reports

HTML Entities

8 Tuning SQL*Plus

Tracing Statements

Controlling the Autotrace Report

Execution Plan

Statistics

Collecting Timing Statistics

Tracing Parallel and Distributed Queries

Execution Plan Output in Earlier Databases

SQL*Plus Script Tuning

COLUMN NOPRINT

SET APPINFO OFF

SET ARRAYSIZE

SET DEFINE OFF

SET FLUSH OFF

SET LINESIZE

SET LONGCHUNKSIZE

SET PAGESIZE

SET SERVEROUTPUT

SET SQLPROMPT

SET TAB

SET TERMOUT

SET TRIMOUT ON

SET TRIMSPOOL ON 8-10

UNDEFINE

9 SQL*Plus Security

PRODUCT_USER_PROFILE Table

Creating the PUP Table

PUP Table Structure

Description and Use of PUP Columns

PUP Table Administration

Disabling SQL*Plus, SQL, and PL/SQL Commands

Creating and Controlling Roles

Disabling SET ROLE

Disabling User Roles

Disabling Commands with SQLPLUS -RESTRICT

Program Argument Security

10 Database Administration with SQL*Plus

Overview

Introduction to Database Startup and Shutdown

Database Startup

Database Shutdown

Redo Log Files

ARCHIVELOG Mode

Database Recovery

11 SQL*Plus Globalization Support

Configuring Globalization Support in Command-line SQL*Plus

SQL*Plus Client

Oracle Database

NLS_LANG Environment Variable

Viewing NLS_LANG Settings

Setting NLS_LANG