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 SQLPlus 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 SQLPlus 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: A Guide to SQL*Plus Syntax

Computers & Technology

Gennick, Jonathan

Programming Languages

O'Reilly Media

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:
<ul>
<li>Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).</li>
<li>Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)</li>
<li>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.</li>
<li>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.</li>
</ul>"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

SQL Pocket Guide

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.

Oracle Regular Expressions Pocket Reference: Tutorial & Quick Reference

Linsley, Peter

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book-now updated for Oracle 10g-is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user. The new second edition of Oracle SQL Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus-and maybe some you didn't realize you could perform. With Oracle SQL Plus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQLPlus environment and much more It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction. This book is truly the definitive guide to SQL Plus. It's an indispensable resource for those who are new to SQL Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Oracle SQL*Plus: The Definitive Guide

Computer Science

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:
<ul>
<li>Differentiate between SQL and SQLPlus</li>
<li>Interact with SQLPlus from both the command line and the web browser</li>
<li>Select, insert, update, and delete data</li>
<li>Format both text and HTML reports with SQLPlus</li>
<li>Specify SQLPlus commands and format elements</li>
<li>Tune SQL queries</li>
</ul>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.

Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:
<ul>
<li>Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE))</li>
<li>Microsoft SQL Server 2005</li>
<li>MySQL 5</li>
<li>IBM DB2 8.2</li>
<li>PostreSQL 8.1 database</li>
</ul>

Sams Teach Yourself PL/SQL in 21 Days is the ultimate hands-on guide that teaches you how to take full advantage of Oracle's powerful database systems, including Web-based J/SQL implementations. In addition, you will learn to streamline client/server communications and queries and use a variety of enhancements, such as triggers and packages, which make Oracle application development much smoother.Whether you are a beginning programmer or an accomplished Oracle user, Sams Teach Yourself PL/SQL in 21 Days will help you establish yourself as an Oracle programmer, ready for advancement in this premium database marketplace. By walking you through each element of the PL/SQL language extension, this book helps you to understand the basics of using new and existing Oracle8 objects, as well as complex processing issues. This guide also teaches you to implement PL/SQL in a comprehensive, real-world system.

Teach Yourself Pl/SQL in 21 Days (Sams Teach Yourself)

Luers, Tom

Atwood, Timothy

Sams.

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.

Sams Teach Yourself Pl/SQL in 21 Days

New Internet functionality and support for Linux make Oracle8i a milestone release, and this authoritative guide explains all the tools and techniques administrators need to master this potent new database. Some of the new features covered include an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. You'll discover SQL* Plus basics and tools on your way to finding out more about fine-tuning performance and WebDB strategies. The CD-ROM includes a sample Oracle 8i database, sample scripts, and SQL*Plus references.

Oracle8i DBA Bible

McCullough-Dieter, Carol

Linker, Gerrit-Jan

wiley

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains What you'll learn Create databases, tables, and indexes Query and manipulate data Store and manage XML inside the database Move business logic into the database Resolve common performance problems. Build reports that matter to your business. Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back end database, and the database administrators who create, manage, and secure those databases. Table of Contents Getting Started with SELECT Elementary Programming Nulls and Other Pit

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice in SQL Server)

Dye, David

Sack, Joseph

Brimhall, Jason

Roberts, Timothy

Sheffield, Wayne

Apress

See the best price to sell, buy, or rent books by Gennick, Jonathan. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Gennick, Jonathan

See the best price to sell, buy, or rent books by Gennick, Jonathan. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Oracle SQL Plus Pocket Reference: A Guide to SQL*Plus Syntax

SQL Pocket Guide

Oracle Regular Expressions Pocket Reference: Tutorial & Quick Reference

Oracle SQL*Plus: The Definitive Guide

Oracle SQLPlus Pocket Reference: A Guide to SQLPlus Syntax

SQL Pocket Guide

Teach Yourself Pl/SQL in 21 Days (Sams Teach Yourself)

Sams Teach Yourself Pl/SQL in 21 Days

Oracle8i DBA Bible

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice in SQL Server)