技术细节
作者 |
Lex deHaan, Karen Morton, Tim Gorman, Inger Jørgensen, Daniel Fink |
分类 |
Development software |
页数 |
459 pages |
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
<b>What you’ll learn</b>
- How to create database tables and define their relationships
- How to add data to your tables, then change and delete that data
- How to write database queries that generate accurate results
- How to avoid common traps and pitfalls in writing SQL queries
- How to take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more
- How to get a handle on Oracle database’s support for object types in the database
<b>Who this book is for</b>
This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.