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