Loading…

Mastering Oracle SQL /

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Mishra, Sanjay
Other Authors: Beaulieu, Alan
Format: Electronic eBook
Language:Inglés
Published: Sebastopol, CA : O'Reilly, ©2004.
Edition:2nd ed.
Subjects:
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • 1. Introduction to SQL
  • 2. WHERE clause
  • 3. Joins
  • 4. Group operations
  • 5. Subqueries
  • 6. Handling temporal data
  • 7. Set operations
  • 8. Hierarchical queries
  • 9. DECODE and CASE
  • 10. Partitioning
  • 11. PL/SQL
  • 12. Objects and collections
  • 13. Advanced group operations
  • 14. Advanced analytic SQL
  • 15. SQL best practices
  • 16. XML
  • 17. Regular expressions
  • 18. Model queries.