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:

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

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

Forewordxix
Prefacexxi
Acknowledgementsxxix
1Introduction to Oracle SQL1
1.1A Little History1
1.2The Basics of Relational Data Modeling8
1.3Structured Query Language (SQL)14
1.4Software Useful for Reading this Book16
1.5Syntax Conventions Used in This Book17
1.6SQL Tools19
1.7The MUSIC Schema34
2New Features of Oracle SQL39
2.1New Features in Oracle Database 10g39
2.2New Features in Oracle Database 9i46
3Oracle Database Architecture51
3.1The Basic Concepts51
3.2The Oracle Instance58
3.3Oracle Database Physical Architecture60
3.4Database Startup and Shutdown65
3.5Enhancing the Physical Architecture67
4The SELECT Statement73
4.1The Basic SELECT Statement73
4.2Types of SELECT Queries81
4.3Other Aspects of the SELECT Statement88
5Filtering Rows97
5.1WHERE Clause Syntax97
5.2WHERE Clause Expression Conditions101
5.3Logical Operators in the WHERE Clause105
5.4Top-N Queries105
6Sorting Rows109
6.1ORDER BY Clause Syntax109
6.2Sorting and Null Values113
6.3Sorting Methods117
7Operators, Conditions, and Pseudocolumns123
7.1Precedence124
7.2Operators124
7.3Conditions131
7.4Pseudocolumns134
8Using SQL*Plus137
8.1Environmental Settings137
8.2Using Scripts and Variables148
8.3Formatting Query Output in SQL*Plus153
8.4Using iSQL*Plus165
9Single-Row Functions175
9.1Types of Functions176
9.2Single-Row Functions176
9.3Combining Functions196
10Joining Tables205
10.1Join Formats206
10.2Types of Joins207
10.3Examining Different Types of Joins210
11Grouping and Summarizing Data235
11.1GROUP BY Clause Syntax235
11.2Types of Group Functions237
11.3Special Grouping Function Behavior245
11.4Using the GROUP BY Clause249
11.5The SPREADSHEET (MODEL) Clause260
12Subqueries267
12.1Types of Subqueries267
12.2Where Can Subqueries Be Used?269
12.3Comparison Conditions and Subqueries269
12.4Demonstrating Subqueries270
13Unusual Query Types285
13.1Composite Queries285
13.2Hierarchical Queries289
13.3Flashback and Versions Queries292
13.4Parallel Queries297
14Expressions301
14.1Types of Expressions302
14.2Regular Expressions305
14.3Oracle Expression Filter309
15Data Manipulation Language (DML)315
15.1What Is DML?315
15.2Transaction Control317
15.3Adding Data (INSERT)324
15.4Changing Data (UPDATE)330
15.5Deleting Data (DELETE)334
15.6Merging New and Old Data (MERGE)336
16Datatypes and Collections339
16.1Simple Datatypes339
16.2Complex and Object Datatypes342
16.3Special Datatypes355
17XML in Oracle357
17.1What Is XML?357
17.2Using XML in Oracle360
17.3Metadata Views380
18Tables383
18.1What Is a Table?383
18.2CREATE TABLE Syntax387
18.3Creating Different Table Types388
18.4Changing Table Structure407
18.5Dropping a Table414
18.6Adding Comments to Tables416
18.7The Recycle Bin420
18.8Metadata Views421
19Views425
19.1What Is a View?425
19.2Types and Uses of Views426
19.3CREATE VIEW Syntax427
19.4Changing and Dropping Views433
19.5Working with Views435
19.6Metadata Views441
19.7Data Dictionary Views (Metadata)442
20Constraints447
20.1What Are Constraints?448
20.2Managing Constraints449
20.3Adding, Modifying, and Dropping Constraints460
20.4Metadata Views469
21Indexes and Clusters471
21.1Indexes471
21.2Clusters484
21.3Metadata Views487
22Sequences and Synonyms489
22.1Sequences489
22.2Synonyms498
22.3Metadata Views501
23Security503
23.1Users503
23.2Privileges511
23.3Grouping Privileges Using Roles522
23.4Metadata Views530
24Basic PL/SQL531
24.1What is PL/SQL?531
24.2Why Is PL/SQL a Programming Language?532
24.3Variables and Datatypes in PL/SQL541
24.4Retrieving Data in PL/SQL543
24.5Changing Data in PL/SQL549
24.6Dynamic SQL550
24.7Control Structures553
24.8Objects and Methods567
24.9Oracle-Provided Packages567
24.10Metadata Views568
Appendix ASchema Scripting569
Appendix BUtility Scripts623
Appendix CSources of Information625
Index627

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >