Beginning Oracle SQL

作者:de Haan, Lex; Fink, Daniel; Gorman, Tim

页数:448

出版时间:2009-12

价格:$ 45.19

isbn号码:9781430271970

图书标签:Oracle数据库软件开发SQL&PL/SQL

承接 住宅 自建房 室内改造 装修设计 免费咨询 QQ：624617358 一级注册建筑师 亲自为您回答、经验丰富，价格亲民。无论项目大小，都全力服务。期待合作，欢迎咨询！QQ：624617358

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 What you'll learn * 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 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 * Object-Relational Features

用户评价

Oracle经典入门书籍

一般

Oracle经典入门书籍

Oracle经典入门书籍

Oracle经典入门书籍