List of Examples

2-1 Storing and Restoring SQL*Plus System Variables
3-1 The tnsnames.ora entry for the sales database
3-2 Start a command-line session to the sales database using the net service name
3-3 Full connection identifier for SALES1
3-4 Start a command-line session to the sales database using the easy connection identifier
3-5 CONNECT to the sales database using the easy connection identifier
3-6 Start a connectionless SQL*Plus session with /NOLOG
3-7 Starting SQL*Plus
4-1 Using the DESCRIBE Command
4-2 Using the DESCRIBE Command
4-3 Entering a SQL Command
4-4 Entering a SQL*Plus Command
4-5 Turning Autocommit On
4-6 Interpreting an Error Message
5-1 Using a System Editor to Write a SQL Script
5-2 Listing the Buffer Contents
5-3 Making an Error in Command Entry
5-4 Correcting the Error
5-5 Appending Text to a Line
5-6 Adding a Line
5-7 Running a Script
5-8 Defining a Substitution Variable
5-9 Using Substitution Variables
5-10 Using Double Ampersands
5-11 Passing Parameters through START
5-12 Prompting for and Accepting Input
5-13 Using PROMPT and ACCEPT in Conjunction with Substitution Variables
5-14 Creating, Referencing, and Displaying REFCURSOR Bind Variables
5-15 Using REFCURSOR Variables in Stored Procedures
5-16 Using REFCURSOR Variables in Stored Functions
6-1 Changing a Column Heading
6-2 Splitting a Column Heading
6-3 Setting the Underline Character
6-4 Formatting a NUMBER Column
6-5 Formatting a Character Column
6-6 Formatting an XMLType Column
6-7 Copying a Column's Display Attributes
6-8 Resetting Column Display Attributes to their Defaults
6-9 Printing a Line of Characters after Wrapped Column Values
6-10 Suppressing Duplicate Values in a Break Column
6-11 Inserting Space when a Break Column's Value Changes
6-12 Combining Spacing Techniques
6-13 Computing and Printing Subtotals
6-14 Computing and Printing a Grand Total
6-15 Computing the Same Type of Summary Value on Different Columns
6-16 Computing Multiple Summary Lines on the Same Break Column
6-17 Removing COMPUTE Definitions
6-18 Placing a Top and Bottom Title on a Page
6-19 Placing a Header on a Report
6-20 Positioning Title Elements
6-21 Indenting a Title Element
6-22 Displaying the Current Page Number in a Title
6-23 Formatting a System-Maintained Value in a Title
6-24 Creating a Master/Detail Report
6-25 Setting Page Dimensions
6-26 Sending Query Results to a Printer
7-1 Creating a Report Interactively
7-2 Creating a Report using the SQLPLUS Command
8-1 Creating a PLAN_TABLE
8-2 Creating the PLUSTRACE Role
8-3 Granting the PLUSTRACE Role
8-4 Tracing Statements for Performance Statistics and Query Execution Path
8-5 Tracing Statements Without Displaying Query Data
8-6 Tracing Statements With Parallel Query Option
8-7 To monitor disk reads and buffer gets.
9-1 Setting Restrictions in the PUP Table
10-1 Starting an Instance
10-2 Mounting the Database
10-3 Opening the Database
10-4 Shutting Down the Database
11-1 Configuring Japanese Support in SQL*Plus on Windows
11-2 Configuring Japanese Support in SQL*Plus on UNIX
11-3 Configuring Japanese Support in Oracle Database
B-1 Copying from a Remote Database to Your Local Database Using CREATE