Oracle SQL Revealed - Programmer Books

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. Oracle SQL Revealed book covers features that are often not well known, and sometimes not implemented in competing products.