Oracle Database 10g SQL Development Guide

Author: [USA] J. Price / Feng Rui / You Yuanxia
Publisher:
Publish Date: 2005-05-01
Features: The main content of this book includes: performing query, insert, update, and delete operations on databases; writing PL/SQL stored procedures, packages, and triggers. Creating database tables, sequences, indexes, views, and users; using SQLPlus to execute SQL statements, scripts, and reports. Using analytical functions for complex calculations; understanding the basics of running SQL using Java via JDBC. Using large objects to store character and binary data up to 128TB; defining database types and creating objects to handle advanced data. Using all new features of Oracle Database 10g, such as BINARY_FLOAT and BINARY_DOUBLE types, MODEL clause, and so on. Using optimization techniques to achieve truly efficient SQL statements. This book comprehensively and in-depthly discusses how to use Structured Query Language (SQL) statements to access Oracle databases, as well as how to write programs containing SQL statements using PL/SQL (Procedural Language/SQL). Written by Jason Price, former product manager at Oracle, this book is based on the newly released SQL:2003 standard and provides a detailed introduction to the new features and functions of Oracle Database 10g. The content of the book is systematic and authoritative, helping readers quickly master the core knowledge of SQL.