책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9780596004415
· 쪽수 : 120쪽
· 출판일 : 2002-10-01
책 소개
목차
Interacting with SQL*Plus
Starting SQL*Plus
Entering Commands
Strings in SQL*Plus Commands
Specifying Filenames
Naming Variables
Selecting Data
The SELECT Statement
Null Values
CASE Expressions
Table Joins (Oracle8i)
Table Joins (Oracle9i)
Summary Queries
Unions
Partition Operations
Inserting Data
Inserting One Row
Inserting the Results of a Query
Multitable Inserts (Oracle9i)
Updating Data
Simple Updates
Noncorrelated Subqueries in the SET Clause
Correlated Subqueries in the SET Clause
Deleting Data
Simple Deletes
Deleting All Rows (TRUNCATE)
Deleting Duplicate Rows
Merging Data (Oracle9i)
Transaction Management
SET TRANSACTION
SAVEPOINT
COMMIT
ROLLBACK
Text Reports
Column Headings
Column Formats
Page Width and Length
Page Headers and Footers
Page Breaks
Report Breaks
Tuning SQL
Creating the Plan Table
Explaining a Query
Querying the Plan Table
Using Optimizer Hints
SQL*Plus Format Elements
Formatting Numbers
Formatting Character Strings
Formatting Dates
SQL*Plus Command Reference
