Oracle SQL*Plus : pocket reference

著者

書誌事項

Oracle SQL*Plus : pocket reference

Jonathan Gennick

O'Reilly, 2002, c2003

2nd ed

大学図書館所蔵 件 / 全1件

この図書・雑誌をさがす

注記

Includes index

On cover: Covers Oracle9i

内容説明・目次

内容説明

SQL*Plus is available at every Oracle site - from the largest data warehouse to the smallest single-user system - and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This pocket reference offers quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. This 2nd edition includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQL*Plus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.

目次

Introduction 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 Index

「Nielsen BookData」 より

詳細情報

ページトップへ