MODEL clause, and advanced grouping syntax---features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing over
This book describes how the Oracle RDBMS arrives at an Execution Plan. This book covers useful tools useful for getting Explain Plans as well as useful Hints used to give directives to the Cost-Base
An expert guide to working with SQL Server in a mixed-database environmentMicrosoft SQL Server Administration for Oracle DBAs is the ideal resource for experienced Oracle database professionals looki
Written by an Oracle ACE, this Oracle Press guide helps experienced Microsoft SQL Server database administrators (DBAs) work seamlessly with the Oracle Database in a mixed-database environment. Oracl
Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Datab
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classicMastering Oracle SQL and SQL*Plus b
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to buil
Covering SQL Developer fundamentals as well more intermediate and advanced topics, this book uses in-depth explanation and detailed examples to help you get the most out of Oracle SQL Developer. The b
“The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over.” –Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine P
As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers ac
Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query—including new features f
Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational data
This textbook outlines the structure of Oracle?‥?s primary database language PL/SQL as a server-side Web scripting language for developing AJAX Web applications. It covers topics like Oracle SQL, Ora
Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and to
Write powerful SQL statements and PL/SQL programsLearn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracl
A handbook covering PL/SQL provides a wide range of tips and techniques for insuring coding style consistency and coding approaches for the best performance of PL/SQL programs and furnishes informatio
With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing t
In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe d
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken—you need to get up to speed on PL/SQL programming, ri
Improve the performance of relational databases with indexes designed for today's hardware Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprisi
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
In this SQL primer/CD-ROM package, De Haan (applied mathematics, Technical University, The Netherlands) shows developers, administrators, system architects, and hobbyists how to write SQL and how to m
This examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 green screen applications, the SQL scripting tool within iSeries Navigator,
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or g
This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and
Introduces a series of effective techniques to solve essential problems in the Oracle database using PL/SQL, with a focus on the stored procedures, how to code them, and practical uses for them in the
PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wid
In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Gurry's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracl
A complete guide to SQL*Loader, a utility used to move data from external files into an Oracle database, offers step-by-step instruction in the various applications of SQL*Loader, providing a task-ori
Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two
