Oracle SQL*Plus

2002 Computers

Author : Jonathan Gennick
Release : 2002
Genre : Computers
Kind : eBook
Book Rating : 419/5 ( reviews)

GET EBOOK

Book Synopsis Oracle SQL*Plus by : Jonathan Gennick

Download or read book Oracle SQL*Plus written by Jonathan Gennick. This book was released on 2002. Available in PDF, EPUB and Kindle. Book excerpt: SQLPlus 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 SQLPlus can be. This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus 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 SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQLPlus 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 SQLPlus 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.

Oracle SQL*Plus Pocket Reference

2004-11-11 Computers

Author : Jonathan Gennick
Release : 2004-11-11
Genre : Computers
Kind : eBook
Book Rating : 694/5 ( reviews)

GET EBOOK

Book Synopsis Oracle SQL*Plus Pocket Reference by : Jonathan Gennick

Download or read book Oracle SQL*Plus Pocket Reference written by Jonathan Gennick. This book was released on 2004-11-11. Available in PDF, EPUB and Kindle. Book excerpt: 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 10g to include information on both SQLPlus 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 SQLPlus, 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.

SQL Pocket Guide

2004 Database management

Author : Jonathan Gennick
Release : 2004
Genre : Database management
Kind : eBook
Book Rating : 122/5 ( reviews)

GET EBOOK

Book Synopsis SQL Pocket Guide by : Jonathan Gennick

Download or read book SQL Pocket Guide written by Jonathan Gennick. This book was released on 2004. Available in PDF, EPUB and Kindle. Book excerpt: This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK). Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate) Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries. Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site. "If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book."--Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com

Oracle SQL*Plus

2000 Computers

Author : Jonathan Gennick
Release : 2000
Genre : Computers
Kind : eBook
Book Rating : /5 ( reviews)

GET EBOOK

Book Synopsis Oracle SQL*Plus by : Jonathan Gennick

Download or read book Oracle SQL*Plus written by Jonathan Gennick. This book was released on 2000. Available in PDF, EPUB and Kindle. Book excerpt: Despite the wide use of SQL *Plus, few developers and database administrators know how powerful it really is. And the syntax can sometimes be tricky. This portable guide provides a quick reference to subjects such as interacting with SQL *Plus, selecting data, formatting reports, writing scripting, and tuning SQL. There's also a command reference.

Oracle Regular Expressions Pocket Reference

2003-09-05 Computers

Author : Jonathan Gennick
Release : 2003-09-05
Genre : Computers
Kind : eBook
Book Rating : 491/5 ( reviews)

GET EBOOK

Book Synopsis Oracle Regular Expressions Pocket Reference by : Jonathan Gennick

Download or read book Oracle Regular Expressions Pocket Reference written by Jonathan Gennick. This book was released on 2003-09-05. Available in PDF, EPUB and Kindle. Book excerpt: Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data.This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

Popular eBooks

Oracle SQL*Plus

Oracle SQL*Plus Pocket Reference

SQL Pocket Guide

Oracle SQL*Plus

Oracle Regular Expressions Pocket Reference

You may also like...