This manual covers the Oracle SQL*Plus Pocket Reference, a guide designed to enhance the effectiveness of Oracle's SQL*Plus tool. SQL*Plus is a widely utilized interactive query tool found across all Oracle database environments. This reference is particularly beneficial for database administrators and developers who seek a deeper understanding and more complete utilization of SQL*Plus capabilities. It details SQL*Plus syntax, format options, and new features introduced in Oracle Database 10g, providing practical instructions for interacting with SQL*Plus, managing data, and generating reports.
The purpose of this manual is to serve as a comprehensive, on-the-job resource for users of Oracle SQL*Plus. It clearly differentiates between SQL and SQL*Plus, guides users on command-line and browser interactions, and explains data manipulation techniques. Furthermore, it covers report formatting in both text and HTML, the specification of commands and format elements, and query tuning. Updated for Oracle Database 10g, this reference includes new SQL information such as the MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN, making it an indispensable companion for maximizing SQL*Plus performance and functionality.
The Oracle SQLPlus 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, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:
- Differentiate between SQL and SQLPlus
- 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 SQLPlus
- 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 SQLPlus 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 SQL
Plus, the bestselling Oracle SQLPlus: 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.
Author: Gennick, Jonathan
Publisher: O'Reilly Media
Illustration: n
Language: ENG
Title: Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax
Pages: 00154 (Encrypted EPUB)
On Sale: 2015-02-18
SKU-13/ISBN: 9780596008857
Category: Computers : Programming Languages - SQL
The Oracle SQLPlus 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, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:
- Differentiate between SQL and SQLPlus
- 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 SQLPlus
- 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 SQLPlus 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 SQL
Plus, the bestselling Oracle SQLPlus: 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.
Author: Gennick, Jonathan
Publisher: O'Reilly Media
Illustration: n
Language: ENG
Title: Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax
Pages: 00154 (Encrypted EPUB)
On Sale: 2015-02-18
SKU-13/ISBN: 9780596008857
Category: Computers : Programming Languages - SQL
