Oracle SQL Recipes
A Problem-Solution Approach
Paperback Engels 2009 2009e druk 9781430225096Samenvatting
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side. Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems
Specificaties
Lezersrecensies
Inhoudsopgave
- The Basics
- Summarizing and Aggregating Data
- Querying from Multiple Tables
- Creating and Deriving Data
- Common Query Patterns
- Working with Date and Time Values
- Strings
- Working with Numbers
- Managing Transactions
- Data Dictionary
- Common Reporting Problems
- Cleansing Data
- Tree-Structured Data
- Working with XML Data
- Partitioning
- LOBs
- Database Administration
- Object Management
- SQL Monitoring and Tuning
- Database Troubleshooting
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan