Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover developments in Oracle’s version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.
- Takes an example-based approach, with clear and authoritative explanations
- Introduces both SQL and the query tools used to execute SQL statements
- Shows how to create tables, populate them with data, and then query that data to generate business results
Inhoudsopgave
1: Relational Database Systems and Oracle. 2: Introduction to SQL and the Interactive Query Tools. 3: Data Definition, Part I. 4: Retrieval: The Basics. 5: Retrieval: Functions. 6: Data Manipulation. 7: Data Definition, Part II. 8: Retrieval: Multiple Tables and Aggregation. 9: Retrieval: Advanced Features. 10: Views. 11: Writing Automating SQL Scripts. 12: Object-Relational Features. Appendix A: The Seven Case-study Tables.