SQL*Plus User's Guide and Reference
Library
Product
SQL*Plus
®
User's Guide and Reference
Preface
Understanding SQL*Plus
Introduction
Overview of SQL*Plus
Using this Guide
What You Need to Run SQL*Plus
Learning SQL*Plus Basics
Getting Started
Entering and Executing Commands
Getting Help
Manipulating Commands
Editing Commands
Saving Commands for Later Use
Writing Interactive Commands
Using Bind Variables
REFCURSOR Bind Variables
Tracing Statements
Formatting Query Results
Formatting Columns
Clarifying Your Report with Spacing and Summary Lines
Defining Page and Report Titles and Dimensions
Storing and Printing Query Results
Accessing SQL Databases
Connecting to the Default Database
Connecting to a Remote Database
Copying Data from One Database to Another
Copying Data between Tables on One Database
Reference
Command Reference
SQL*Plus Command
Summary
@ ("at" sign)
@@ (double "at" sign)
/ (slash)
ACCEPT
APPEND
BREAK
BTITLE
CHANGE
CLEAR
COLUMN
COMPUTE
CONNECT
COPY
DEFINE
DEL
DESCRIBE
DISCONNECT
EDIT
EXECUTE
EXIT
GET
HELP
HOST
INPUT
LIST
PAUSE
PRINT
PROMPT
REMARK
REPFOOTER
REPHEADER
RUN
RUNFORM
SAVE
SET
SHOW
SPOOL
SQLPLUS
START
STORE
TIMING
TTITLE
UNDEFINE
VARIABLE
WHENEVER OSERROR
WHENEVER SQLERROR
COPY Command Messages and Codes
Release 3.3 Enhancements
SQL*Plus Release 3.3 Enhancements
SQL*Plus Limits
SQL Command List
Security
PRODUCT_USER_PROFILE Table
Roles
SQL*Plus Commands from Earlier Releases
BTITLE (old form)
COLUMN DEFAULT
DOCUMENT
NEWPAGE
SET BUFFER
SET DOCUMENT
SET SCAN
SET SPACE
SET TRUNCATE
TTITLE (old form)
GLOSSARY
Copyright © 1996 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065
Library
Product