Oracle SQL by example
โ Scribed by Rischert, Alice
- Publisher
- Prentice Hall
- Year
- 2010
- Tongue
- English
- Leaves
- 961
- Series
- Prentice Hall professional Oracle series
- Edition
- 4th edition
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Table of Contents
Foreword xxxiPreface xxxivChapter 1: SQL and Data 1Chapter 2: SQL: The Basics 49Chapter 3: The WHERE and ORDER BY Clauses 101Chapter 4: Character, Number, and Miscellaneous Functions 133Chapter 5: Date and Conversion Functions 189Chapter 6: Aggregate Functions, GROUP BY, and HAVING Clauses 263Chapter 7: Equijoins 285Chapter 8: Subqueries 323Chapter 9: Set Operators 377Chapter 10: Complex Joins 399Chapter 11: Insert, Update, and Delete 429Chapter 12: Create, Alter, and Drop Tables 503Chapter 13: Indexes, Sequences, and Views 571Chapter 14: The Data Dictionary, Scripting, and Reporting 615Chapter 15: Security 661Chapter 16: Regular Expressions and Hierarchical Queries 695Chapter 17: Exploring Data Warehousing Features 741Chapter 18: SQL Optimization 803Appendix A: Answers to Quiz Questions 839Appendix B: SQL Formatting Guide 855Appendix C: SQL*Plus Command Reference 859Appendix D: STUDENT Database Schema 873Appendix E: Table and Column Descriptions 875Appendix F: Additional Example Tables 881Appendix G: Navigating the Oracle Documentation 887Appendix H: Resources 893Appendix I: Oracle Data Types 897Index 899
โฆ Subjects
SQL (Langage de programmation);SQL (Computer program language);Livres รฉlectroniques;Oracle (Computer file);Oracle (Logiciel)
๐ SIMILAR VOLUMES
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g,<i><b>Oracle PL/SQL by Example</b></i>, Fourth Edition covers all the fundamentals, from PL/SQL syntax an
Start developing applications with Oracle PL/SQL - fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third E
<span><span><p><br> </p><p>The<br>book...has enough depth for even a seasoned professional to pick up<br>enough tips to pay back the price of the book</p><p>many times<br>over.</p><p>Dr.<br>Paul Dorsey, President, Dulcian, Inc., <em>Oracle</em> Magazine<br>PL/SQL Developer of the Year 2007, and Pre
Using PL/SQL for Oracle Database 12 c , you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle ยฎ PL/SQL by Example, Fifth Edition, teaches all the PL/SQL skills you'll need, through real-world labs, extensive examples, exercise