Library

Product

Contents

• 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
• Using 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

• Starting SQL*Plus and Getting Help
• Starting SQL*Plus Using the SQLPLUS Command
• Getting Help

• Command Reference
• SQL*Plus Command Summary
• @ ("at" sign)
• @@ (double "at" sign)
• / (slash)
• ACCEPT
• APPEND
• ATTRIBUTE
• BREAK
• BTITLE
• CHANGE
• CLEAR
• COLUMN
• COMPUTE
• CONNECT
• COPY
• DEFINE
• DEL
• DESCRIBE
• DISCONNECT
• EDIT
• EXECUTE
• EXIT
• GET
• HELP
• HOST
• INPUT
• LIST
• PASSWORD
• PAUSE
• PRINT
• PROMPT
• REMARK
• REPFOOTER
• REPHEADER
• RUN
• SAVE
• SET
• SHOW
• SPOOL
• START
• STORE
• TIMING
• TTITLE
• UNDEFINE
• VARIABLE
• WHENEVER OSERROR
• WHENEVER SQLERROR

• COPY Command Messages and Codes

• Release 8.0 Enhancements
• SQL*Plus Release 8.0 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
• Index

Info

SQL*Plus User's Guide and Reference
Part Number: A53717-01
HTML TOC File: toc
Copyright (C) 1997, Oracle Corporation

Copyright

SQL*Plus User's Guide and Reference, Release 8.0

Part No. A53717-01

Copyright © 1997 Oracle Corporation

All rights reserved. Printed in the U.S.A.

Contributing Authors: Frank Rovitto

Contributors: Larry Baer, Lisa Colston, Roland Kovacs, Karen Denchfield-Masterson, Alison Holloway, Sanjeev Jhala, Christopher Jones, Anita Lam, Nimish Mehta, Luan Nim, Bud Osterberg, Irene Paradisis, Richard Rendell, Farokh Shapoorjee, Larry Stevens, Andre Touma

This software was not developed for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It is the customer's responsibility to take all appropriate measures to ensure the safe use of such applications if the programs are used for such purposes.

This software/documentation contains proprietary information of Oracle Corporation; it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited.

If this software/documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the following legend is applicable:

Restricted Rights Legend Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988).

Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

If this software/documentation is delivered to a U.S. Government Agency not within the Department of Defense, then it is delivered with "Restricted Rights", as defined in FAR 52.227-14, Rights in Data - General, including Alternate III (June 1987).

The information in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free.

Oracle, SQL*Plus, SQL*Forms, SQL*Net and Oracle Spatial Data Option are registered trademarks and Oracle7, Oracle8, Designer/2000, Developer/2000, Oracle Text Server Option, Oracle Mobile Agents, Oracle Media Objects, and Oracle InterOffice are trademarks of Oracle Corporation.

All other products or company names are used for identification purposes only, and may be trademarks of their respective owners.

Copyright © 1997 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product