Mastering Oracle SQL / Sanjay Mishra and Alan Beaulieu
- Author
- Mishra, Sanjay
- Additional Titles
- Oracle SQL
- Published
- Sebastopol, CA : O'Reilly, [2004]
- Copyright Date
- ©2004
- Edition
- 2nd ed.
- Physical Description
- 1 online resource (xvii, 472 pages) : illustrations
- Additional Creators
- Beaulieu, Alan
Access Online
- Language Note
- English.
- 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.
- Summary
- 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 a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that lea.
- Subject(s)
- Genre(s)
- ISBN
- 9780596517472 (electronic bk.)
0596517475 (electronic bk.)
0596006322
9780596006327
9780596552473 (e-book)
0596552475 - Digital File Characteristics
- text file
- Note
- "Covers Oracle database 10g."
- Bibliography Note
- Includes bibliographical references and index.
- Copyright Note
- Copyright © O'Reilly Media, Incorporated 2004
Copyright © O'Reilly Media, Inc. 2004
View MARC record | catkey: 37412195