Oracle SQLPlus Pocket Reference

ISBN: 9780596008857

作者: [美]Jonathan Gennick

出版社: Oreilly & Associates Inc

出版年: 2004-11

页数: 146

定价: $ 11.24

装帧: Pap

内容简介

The "Oracle SQL"Plus Pocket Reference"" is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQL"Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL"Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the "Oracle SQL"Plus Pocket Reference"" to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10"g" features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQL"Plus "Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQL"Plus "Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10"g" to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN. With its quick-reference format and compact size, the "Oracle SQL"Plus Pocket Reference"" follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling "Oracle SQL*Plus: The Definitive Guide." Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.