Oracle SQL*Plus Pocket Reference, 2/e

Jonathan Gennick

  • 出版商: O'Reilly
  • 出版日期: 2002-10-13
  • 售價: $620
  • 貴賓價: 9.5$589
  • 語言: 英文
  • 頁數: 120
  • 裝訂: Paperback
  • ISBN: 0596004419
  • ISBN-13: 9780596004415
  • 相關分類: OracleSQL
  • 已絕版

買這商品的人也買了...

商品描述

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 provides 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 SQL8Plus: 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.

The new 2nd edition of our Oracle SQL*Plus Pocket Reference 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.

Table of Contents

Introduction

Interacting with SQL*Plus

Selecting Data

Inserting Data

Updating Data

Deleting Data

Merging Data (Oracle9i)

Transaction Management

Text Reports

Tuning SQL

SQL*Plus Format Elements

SQL*Plus Command Reference

Index