Available Categories

AdobeMacromediaProgrammingSQLServer AdministrationNetworkingMicrosoft ProductsMac OSLinux systemsMobile devicesXMLCertificationMisc

Available Tutorials

MySQL pocket referenceSQL Bible OracleSql tuningDatabase design for mere mortalsMySQLPostgresqlMicrosoft SQL Server 2000Mastering Oracle SQLOracle PL SQL Language Pocket ReferenceOracle DBA guide to data warehousing and star schemasAdministrator's guide to sql server 2005Sql bible
| More

Mastering Oracle SQL, 2nd Edition

  
• Table of Contents
• Index
• Reviews
• Examples
• Reader Reviews
• Errata
• Academic
Mastering Oracle SQL, 2nd Edition
By Alan Beaulieu, Sanjay Mishra
 
Publisher: O'Reilly
Pub Date: June 2004
ISBN: 0-596-00632-2
Pages: 492
   


Updated to cover Oracle 10g, this new edition of the highly regarded Mastering Oracle SQL has a stronger focus on practical, expert best-practices and on Oracle-specific SQL technique than any other book on the market. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Mastering Oracle SQL
Mastering Oracle SQL, 2nd Edition
Preface
Chapter 1. Introduction to SQL
Chapter 2. The WHERE Clause
Chapter 3. Joins
Chapter 4. Group Operations
Chapter 5. Subqueries
Chapter 6. Handling Temporal Data
Chapter 7. Set Operations
Chapter 8. Hierarchical Queries
Chapter 9. DECODE and CASE
Chapter 10. Partitioning
Chapter 11. PL/SQL
Chapter 12. Objects and Collections
Chapter 13. Advanced Group Operations
Chapter 14. Advanced Analytic SQL
Chapter 15. SQL Best Practices
Chapter 16. XML
Chapter 17. Regular Expressions
Chapter 18. Model Queries
Appendix A. Oracle's Old Join Syntax
Colophon

| More
internet connection