Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Jonathan Gennick
Oracle SQL*Plus Pocket Reference
Oracle SQL*Plus Pocket Reference
1. Oracle SQL*PlusPocket Reference
Introduction
Acknowledgments
Conventions
Interacting with SQL*Plus
Starting SQL*Plus
Syntax for the sqlplus command
Entering Commands
Entering SQL*Plus commands
Entering SQL statements
Entering PL /SQL blocks
Strings in SQL*Plus Commands
Specifying Filenames
Naming Variables
Using column aliases
Selecting Data
The SELECT Statement
Selecting columns from a table
Ordering query results
Restricting query results
Null Values
Using the NVL function
Table Joins
Inner and outer joins
Summary Queries
Using aggregate functions
Using GROUP BY
Restricting summarized results
Using ALL and DISTINCT
Unions
Formatting Reports
Column Headings
Column Formats
Page Width and Length
Page Headers and Footers
Defining a title
Getting the date into a title
Page Breaks
Report Breaks
The BREAK command
The COMPUTE command
Tuning SQL
Creating the Plan Table
Explaining a Query
EXPLAIN PLAN syntax
EXPLAIN PLAN example
Querying the Plan Table
Using Optimizer Hints
Optimizer goal hints
Access method hints
Join order hints
Join operation hints
Parallel execution hints
SQL*Plus Format Elements
Formatting Numbers
Formatting Character Strings
Formatting Dates
SQL*Plus Command Reference
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
PRINT
PROMPT
QUIT
RECOVER
REMARK
REPFOOTER
REPHEADER
RUN
SAVE
SET
SHOW
SHUTDOWN
SPOOL
START
STARTUP
STORE
TIMING
TTITLE
UNDEFINE
VARIABLE
WHENEVER
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Oracle SQL*Plus Pocket Reference
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset