Oracle SQL*Plus

SQL*Plus and SQL Syntax - Covers Oracle Database 10g

Jonathan Gennick - Collection Pocket reference

146 pages, parution le 05/08/2005 (3^eme édition)

Ajouter à une liste

Indisponible

Résumé

SQL*Plus is an interactive query tool that's ubiquitous in the Oracle world. It's 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.

The third edition of this popular pocket guide provides quick reference information on SQL*Plus syntax and format elements, including new Oracle Database 10g features. It concisely describes interacting with SQL*Plus, formatting both text and HTML reports with SQL*Plus, and tuning SQL queries using both optimizer hints and the plan table. This new edition covers browser-based iSQL*Plus, the ability to generate HTML, new commands and SET options, and much more. It also contains expanded information on the SQL statements most commonly issued from SQL*Plus (SELECT, INSERT, UPDATE, DELETE, MERGE, COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION) and adds coverage of new SQL features such as the Oracle Database 10g SELECT statement's MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.

L'auteur - Jonathan Gennick

Jonathan Gennick est administrateur de base de données Oracle. Il est aussi écrivain et éditeur. Il est l'auteur de Oracle SQL*Plus : The Definitive Guide, dont proviennent les informations de ce guide, et de plusieurs autres ouvrages sur Oracle.

Sommaire

Introduction
Command-Line SQL*Plus
Browser-Based SQL*Plus
Selecting Data
Modeling Data
Inserting Data
Updating data
Deleting Data
Merging Data (Oracle9i and Higher)
Transaction Management
Formatting Text Reports
Formatting Text Reports
Formatting HTML Reports
Tuning SQL
SQL*Plus Format Elements
SQL*Plus Command Reference
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	O'Reilly
Auteur(s)	Jonathan Gennick
Collection	Pocket reference
Parution	05/08/2005
Édition	3^eme édition
Nb. de pages	146
Format	10,5 x 17,5
Couverture	Broché
Poids	150g
Intérieur	Noir et Blanc
EAN13	9780596008857
ISBN13	978-0-596-00885-7