Oracle SQL: Jumpstart with Examples

Oracle SQL: Jumpstart with Examples

by Gavin JT Powell, Carol McCullough-Dieter
     
 

ISBN-10: 1555583237

ISBN-13: 9781555583231

Pub. Date: 10/07/2004

Publisher: Elsevier Science

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: 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:

…  See more details below

Overview

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: 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 tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

• Each of the hundreds of SQL code examples was tested on a working Oracle 10g 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

Read More

Product Details

ISBN-13:
9781555583231
Publisher:
Elsevier Science
Publication date:
10/07/2004
Pages:
688
Product dimensions:
1.44(w) x 7.50(h) x 9.25(d)

Related Subjects

Table of Contents

1Introduction to Oracle SQL1
2New features of Oracle SQL39
3Oracle database architecture51
4The SELECT statement73
5Filtering rows97
6Sorting rows109
7Operators, conditions, and pseudocolumns123
8Using SQL Plus137
9Single-row functions175
10Joining tables205
11Grouping and summarizing data235
12Subqueries267
13Unusual query types285
14Expressions301
15Data manipulation language (DML)315
16Datatypes and collections339
17XML in Oracle357
18Tables383
19Views425
20Constraints447
21Indexes and clusters471
22Sequences and synonyms489
23Security503
24Basic PL/SQL531
App. ASchema scripting569
App. BUtility scripts623

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >