Oracle SQL by Example
Author: Alice Rischert
Creating and using tables, views, indexes, and sequences
Working in SQL*Plus and iSQL*Plus environments
Oracle functions in depth—especially number, character, date, timestamp, interval, time zone, aggregate, and analytical functions
All types of joins, including equijoins, outer joins, self joins and ANSI join syntax options
Every type of subquery, including correlated and scalar subqueries, set operators, hierarchical queries, flashback queries, data dictionary, object-relational features, regular expressions, and more
Common pitfalls to avoid, and solutions for common mistakes
Practical performance, security, and architectural solutions
Insights, tips, and tricks-of-the-trade from an experienced Oracle professional
For every database developer, administrator, designer or architect, regardless of experience!
Code:
