579:-

Funktionen begränsas av dina webbläsarinställningar (t.ex. privat läge).

Uppskattad leveranstid 7-12 arbetsdagar

Fri frakt för medlemmar vid köp för minst 249:-

423 sidor
2009

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 coverdevelopments in Oracles 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

What youll learn

How to create database tables and define their relationships
How to add data to your tables, thenchange 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 databases support for object types in the database

Who this book is for

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.

Table of Contents

Relational Database Systems and Oracle

Introduction to SQL, AQL*Plus, and SQL Developer

Data Definition, Part I

Retrieval: The Basics

Retrieval: Functions

Data Manipulation

Data Definition, Part II

Retrieval: Multiple Tables and Aggregation

Retrieval: Some Advanced Features

Views

Writing and Automating SQL*Plus Scripts