買這商品的人也買了...
相關主題
商品描述
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
What you'll learn
- Recognize common query patterns and apply their corresponding solutions.
- Solve common reporting problems such as sorting rows into buckets.
- Troubleshoot SQL performance problems.
- Create and manage database objects such as tables, indexes, and views.
- Work with XML and tree-structured data.
- Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL.
Who is this book for?
Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you.
About the Apress Recipes Series
Apress Recipes series books are carefully selected compendiums of solutions and techniques to help you solve the difficulties that regularly beset developers when they are learning a new language or technology. The recipes are short, and each provides a step–by–step explanation and working code example that allows you to successfully solve your problems and progress with your project.
商品描述(中文翻譯)
你曾經遇到過需要撰寫新類型的查詢或被要求創建一個陌生的資料庫物件嗎？在這種情況下，你可能希望有一個良好且可靠的範例來建立，而不是被迫閱讀Oracle手冊中的鐵路式語法圖表。這本書通過提供經過測試且可行的SQL範例來解決開發人員和資料庫管理員每天面臨的常見問題，從而解放你免於這種單調乏味的工作。當你在壓力下需要快速獲得結果時，《Oracle SQL Recipes》將與你並肩作戰。
本書以範例為基礎，提供了解決日常問題的高質量解決方案。
本書尊重你的時間，將解決方案放在首位，並保持討論的簡潔。
本書解決了最常遇到的SQL問題。
你將學到什麼：
- 辨識常見的查詢模式並應用相應的解決方案。
- 解決常見的報表問題，例如將行分類到桶中。
- 解決SQL性能問題。
- 創建和管理資料庫物件，例如表格、索引和視圖。
- 處理XML和樹狀結構的資料。
- 利用Oracle SQL的分析函數、正則表達式、階層查詢支援和其他強大功能。
這本書適合對Oracle資料庫撰寫SQL的開發人員和資料庫管理員。它也適合那些時間寶貴，只希望有一個好的範例來幫助他們繼續工作的人。如果你想花時間寫SQL而不是閱讀有關它的內容，那麼這本書就是適合你的選擇。
關於Apress Recipes系列：
Apress Recipes系列書籍是精心挑選的解決方案和技巧彙編，旨在幫助你解決在學習新語言或技術時經常遇到的困難。這些範例簡短明瞭，每個範例都提供了逐步解釋和可運行的程式碼範例，讓你能夠成功解決問題並推進你的項目。
