Book description
- 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
Table of contents
Product information
- Title: Oracle SQL Revealed: Executing Business Logic in the Database Engine
- Author(s):
- Release date: April 2018
- Publisher(s): Apress
- ISBN: 9781484233726
You might also like
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition
RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 …
book
Oracle SQL Recipes: A Problem-Solution Approach
Have you ever been faced with a new type of query to write, or been asked …
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …