List of Examples

2-1 Storing and Restoring SQL*Plus System Variables

2-2 A default setting in the Environment Dialog

2-3 Setting ARRAYSIZE in the Environment Dialog

2-4 Setting ECHO in the Environment Dialog

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 (not in iSQL*Plus)

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

7-3 Creating a Dynamic Report

7-4 Creating a Dynamic Report with Parameters

7-5 Creating a Dynamic Script with Parameters and Login Details

7-6 Passing a Connect Identifier to a Dynamic Report

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 Opening the Database

10-5 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