Oracle SQL Revealed

Executing Business Logic in the Database Engine



Bookstore > Books > Oracle SQL Revealed

Price$28.40 - $34.76
Rating
AuthorAlex Reprintsev
PublisherApress
Published2018
Pages389
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484233719
ISBN-139781484233719
EBook Hardcover Paperback

Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products.

Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace.

This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are likely to encounter.

Gain competitive advantage from Oracle SQL; Know when to step up to PL/SQL versus staying in SQL; Become familiar with query transformations and join mechanics; Apply the model clause and analytic functions to business intelligence queries; Make use of features that are specific to Oracle Database, such as row pattern matching; Understand the pros and cons of different SQL approaches to solving common query tasks; Traverse hierarchies using CONNECT BY and recursive subquery factoring.




3 5 4

Similar Books


Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference

by Mark Gurry

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...

Price:  $6.76  |  Publisher:  O'Reilly Media  |  Release:  2002

Beginning Oracle SQL, 3rd Edition

Beginning Oracle SQL, 3rd Edition

by Lex deHaan, Tim Gorman, Inger Jorgensen, Melanie Caffrey

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2014

Practical Oracle SQL

Practical Oracle SQL

by Kim Berg Hansen

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit ...

Price:  $32.87  |  Publisher:  Apress  |  Release:  2020

Oracle SQL Recipes

Oracle SQL Recipes

by Grant Allen, Bob Bryla, Darl Kuhn

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 build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you...

Price:  $39.99  |  Publisher:  Apress  |  Release:  2009

Pro Oracle SQL

Pro Oracle SQL

by Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still

Pro Oracle SQL unlocks the power of SQL in the Oracle Database - one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.You'...

Price:  $5.83  |  Publisher:  Apress  |  Release:  2010

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

by Stelios Charalambides

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tu...

Price:  $33.95  |  Publisher:  Apress  |  Release:  2013

Expert Oracle SQL

Expert Oracle SQL

by Tony Hasler

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systemat...

Price:  $58.31  |  Publisher:  Apress  |  Release:  2014

Beginning Oracle SQL

Beginning Oracle SQL

by Lex deHaan, Karen Morton, Tim Gorman, Inger Jorgensen, Daniel Fink

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 classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover developments in Oracle's version of the SQL query language. Written in an easygoing and e...

Price:  $29.99  |  Publisher:  Apress  |  Release:  2009