Skip Headers
SQL*Plus® User's Guide and Reference
Release 10.2

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

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