Share
Create bookmark
Oracle SQL*Plus: The Definitive Guide
The Definitive Guide
Notes
Please login to add notes
- Table of Contents
-
+
Preface
- Why I Wrote This Book
- Objectives of This Book
- What’s New in the Second Edition?
- Which Platform and Version?
- Structure of This Book
- Obtaining the Scripts and Sample Data
- What About Those Names?
- Conventions Used in This Book
- Using Code Examples
- Comments and Questions
- Acknowledgments from the First Edition
- Second Edition Acknowledgments
-
+
Introduction to SQL*Plus
- + Command-Line SQL*Plus
-
+
Browser-Based SQL*Plus
-
+
A Lightning SQL Tutorial
- + Generating Reports with SQL*Plus
- + Creating HTML Reports
-
+
Advanced Reports
- + Writing SQL*Plus Scripts
-
+
Extracting and Loading Data
-
+
Exploring Your Database
- + Advanced Scripting
- + Tuning and Timing
-
+
The Product User Profile
-
+
Customizing Your SQL*Plus Environment
-
+
SQL*Plus Command Reference
- The Command to Invoke SQL*Plus
-
+
Commands You Can Issue Within SQL*Plus
- Comment Delimiters (/*...*/)
- Double Hyphen (- -)
- At Sign (@)
- Double At Sign (@@)
- Forward Slash (/)
- ACCEPT
- APPEND
- ARCHIVE LOG
- ATTRIBUTE
- BREAK
- BTITLE
- CHANGE
- CLEAR
- COLUMN
- COMPUTE
- CONNECT
- COPY
- DEFINE
- DEL
- DESCRIBE
- DISCONNECT
- EDIT
- EXECUTE
- EXIT
- GET
- HELP
- HOST
- INPUT
- LIST
- PASSWORD
- PAUSE
- PROMPT
- QUIT
- RECOVER
- REMARK
- REPFOOTER
- REPHEADER
- RUN
- SAVE
- SET APPINFO
- SET ARRAYSIZE
- SET AUTOCOMMIT
- SET AUTOPRINT
- SET AUTORECOVERY
- SET AUTOTRACE
- SET BLOCKTERMINATOR
- SET BUFFER
- SET CLOSECURSOR
- SET CMDSEP
- SET COLSEP
- SET COMPATIBILITY
- SET CONCAT
- SET COPYCOMMIT
- SET COPYTYPECHECK
- SET DEFINE
- SET DESCRIBE
- SET DOCUMENT
- SET ECHO
- SET EDITFILE
- SET EMBEDDED
- SET ESCAPE
- SET FEEDBACK
- SET FLAGGER
- SET FLUSH
- SET HEADING
- SET HEADSEP
- SET INSTANCE
- SET LINESIZE
- SET LOBOFFSET
- SET LOGSOURCE
- SET LONG
- SET LONGCHUNKSIZE
- SET MARKUP
- SET MAXDATA
- SET NEWPAGE
- SET NULL
- SET NUMFORMAT
- SET NUMWIDTH
- SET PAGESIZE
- SET PAUSE
- SET RECSEP
- SET RECSEPCHAR
- SET SCAN
- SET SERVEROUTPUT
- SET SHIFTINOUT
- SET SHOWMODE
- SET SPACE
- SET SQLBLANKLINES
- SQLCASE
- SET SQLCONTINUE
- SET SQLNUMBER
- SET SQLPLUSCOMPATIBILITY
- SET SQLPREFIX
- SET SQLPROMPT
- SET SQLTERMINATOR
- SET SUFFIX
- SET TAB
- SET TERMOUT
- SET TIME
- SET TIMING
- SET TRIMOUT
- SET TRIMSPOOL
- SET TRUNCATE
- SET UNDERLINE
- SET VERIFY
- SET WRAP
- SHOW
- SHUTDOWN
- SPOOL
- START
- STARTUP
- STORE
- TIMING
- TTITLE
- UNDEFINE
- VARIABLE
- WHENEVER
- + SQL*Plus Format Elements
- Index
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.
The new second edition of _Oracle SQL_Plus: The Definitive Guide__ clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.
With _Oracle SQL_Plus: The Definitive Guide__, you'll expertly:
write and execute script files
generate ad hoc reports
extract data from the database
query the data dictionary tables
customize an SQLPlus environment
and much more
It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.
This book is truly the definitive guide to SQL_Plus. It's an indispensable resource for those who are new to SQL_Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Programming Languages > JavaScript
Publishers
Publication year : 2007
License: All rights reserved ©
Times read: 143
