Oracle SQL Jumpstart with Examples

Gavin Powell, Carol McCullogh-Dieter - Collection Data Management

652 pages, parution le 03/11/2004

Ajouter à une liste

Indisponible

Résumé

Developers and DBAs use Oracle SOL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SOL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tables, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

Features:

Each of the hundreds of SQL code examples was tested on a working Oracle log database
Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
Authors have four decades of commercial experience between them as developers and database administrators

L'auteur - Gavin Powell

Gavin Powell BSc. Comp.Sci., OCR (Oracle Certified Professional), author of Oracle High Performance Tuning for 9i and 10g and Oracle SQL with Carol McCullogh-Dieter, has nineteen years of diverse experience in database administration and development, using both relational and object databases. His applications experience is both procedural and object-oriented. Powell has consulted for software vendors, internet dot-corns, accounting, banking, financial services, travel, construction, retail, mining, shipping, education and training companies in various parts of the world.

Autres livres de Gavin Powell

Oracle Performance Tuning for 10gR2

Découvrir tous les livres de Gavin Powell

Sommaire

Introduction to Oracle SQL
New Features of Oracle SQL
Oracle Database Architecture
The SELECT Statement
Filtering Rows
Sorting Rows
Operators, Conditions, and Pseudocolumns
Using SQL*Plus
Single-Row Functions
Joining Tables
Grouping and Summarizing Data
Subqueries
Unusual Query types
Expressions
Data Manipulating Language (DML)
Datatypes and Collections
XML in Oracle
Tables
Views
Constraints
Indexes and Clusters
Sequences and Synonyms
Security
Basic PL/SQL

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Elsevier
Auteur(s)	Gavin Powell, Carol McCullogh-Dieter
Collection	Data Management
Parution	03/11/2004
Nb. de pages	652
Format	19 x 23,5
Couverture	Broché
Poids	1404g
Intérieur	Noir et Blanc
EAN13	9781555583231