Oracle SQL*Plus : The Definitive Guide
The #1 Book for SQL*Plus Solutions & Syntax - Updated for Oracle Database 10g
Jonathan Gennick - Collection Oracle/Database
Résumé
SQL*Plus is an interactive query tool that's available at every Oracle site, from the largest data warehouse to the smallest single-user system. The tool continues to be supported and enhanced with each new version of Oracle, including Oracle Database 10g. Yet despite the wide availability and use of SQL*Plus, few Oracle developers and DBAs know how powerful a tool SQL*Plus can be.
Updated thoroughly for Oracle Database 10g and Oracle9i Database, this bestselling book is truly a definitive guide. It describes SQL*Plus from start to finish and provides a quick reference to all of the tool's commands and options. Most importantly, it describes, in step-by-step fashion, how to perform all of the tasks you could possibly want to perform with SQL*Plus. You'll learn how to interact with SQL*Plus via both the command line and your web browser, write and execute script files, generate reports, extract and load data, query data dictionary tables, customize your SQL*Plus environment, and much more.
The second edition contains new information on generating HTML reports from SQL*Plus using the iSQL browser-based tool, loading data via the external table mechanism introduced in Oracle9z Database, and taking advantage of all of the new Oracle9i/10g syntax. A newly written tutorial chapter on SQL is designed to get you up and running quickly in the language you'll most often use from within SQL*Plus. With more than 50,000 copies in print worldwide, Oracle SQL*Plus: The Definitive Guide is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.
"As a longtime SQL*Plus user and proponent, I can honestly say I learned a thing or two from this book myself. If you are serious about learning the command-line interface to the Oracle database (a vital piece of knowledge, in my opinion and experience), this is the bookforyou.lt covers everything from the basics-just getting started-to many of the advanced features. Well done."
Thomas Kyte, VP Core Technology-Oracle Corporation, asktom.oracle.com
"If you think, as I do, that command lines are still the most productive, ubiquitous, and flexible working environment, you'll find this to be the book about using Oracle's command-line tool, SQL *Plus. The second edition is even better than the first. I hope you will enjoy reading it and learn from it, as I did."
GregorTheis, OCP DBA, Sun SCSA, independent Oracle database consultant
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 to SQL*Plus
- Command-Line SQL*Plus
- Browser-Based SQL*Plus
- A Lightning SQL Tutorial
- Generating Reports with SQL*Plus
- Creating HTML Reports
- Advanced Reports
- Writing SQL*Plus Scripts
- Extracting and Loading Data
- Exploring Your Database
- Advanced Scripting
- Tuning and Timing
- The Product User Profile
- Customizing Your SQL*Plus Environment
- A: SQL*Plus Command Reference
- B: SQL*Plus Format Elements
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Jonathan Gennick |
| Collection | Oracle/Database |
| Parution | 06/01/2005 |
| Édition | 2eme édition |
| Nb. de pages | 554 |
| Format | 17,5 x 23,5 |
| Couverture | Broché |
| Poids | 841g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596007461 |
| ISBN13 | 978-0-596-00746-1 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
