+612 9045 4394
Oracle Database 10g The Complete Reference : Oracle Press - Kevin Loney

Oracle Database 10g The Complete Reference

Oracle Press

Paperback Published: 28th September 2004
ISBN: 9780072253511
Number Of Pages: 1392

Share This Book:


RRP $114.95
This title is not in stock at the Booktopia Warehouse and needs to be ordered from our supplier.
Click here to read more about delivery expectations.

Get a thorough understanding of Oracle Database 10"g" from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Acknowledgementsp. xiii
Introductionp. xv
Critical Database Concepts
Oracle Database 10g Architecture Optionsp. 3
Databases and Instancesp. 5
Inside the Databasep. 5
Choosing Architectures and Optionsp. 9
Installing Oracle Database 10g and Creating a Databasep. 11
Overview of Licensing and Installation Optionsp. 13
Upgrading to Oracle Database 10gp. 27
Choosing an Upgrade Methodp. 29
Before Upgradingp. 30
Using the Database Upgrade Assistantp. 30
Performing a Manual Direct Upgradep. 31
Using Export and Importp. 34
Using the Data-Copying Methodp. 35
After Upgradingp. 36
Planning Oracle Applications-Approaches, Risks, and Standardsp. 37
The Cooperative Approachp. 39
Everyone Has "Data"p. 40
The Familiar Language of Oraclep. 41
Some Common, Everyday Examplesp. 45
What Are the Risks?p. 47
The Importance of the New Visionp. 48
How to Reduce the Confusionp. 50
Capitalization in Names and Datap. 57
Normalizing Namesp. 58
Good Design Has a Human Touchp. 58
Understanding the Datap. 62
Toward Object Name Normalizationp. 65
Intelligent Keys and Column Valuesp. 68
The Commandmentsp. 68
SQL and SQL*Plus
The Basic Parts of Speech in SQLp. 73
Stylep. 75
Creating the NEWSPAPER Tablep. 76
Using SQL to Select Data from Tablesp. 76
Select, from, where, and order byp. 80
Logic and Valuep. 82
Another Use for where: Subqueriesp. 91
Combining Tablesp. 95
Creating a Viewp. 97
Basic SQL*Plus Reports and Commandsp. 101
Building a Simple Reportp. 104
Other Featuresp. 114
Checking the SQL*Plus Environmentp. 120
Building Blocksp. 122
Getting Text Information and Changing Itp. 123
Datatypesp. 124
What Is a String?p. 124
Notationp. 126
Concatenation (II)p. 127
How to Cut and Paste Stringsp. 128
Using order by and where with String Functionsp. 145
Reviewp. 148
Searching for Regular Expressionsp. 149
Search Stringsp. 150
Regexp_Substrp. 154
Playing the Numbersp. 163
The Three Classes of Number Functionsp. 164
Notationp. 164
Single-Value Functionsp. 168
Aggregate Functionsp. 175
List Functionsp. 182
Finding Rows with MAX or MINp. 183
Precedence and Parenthesesp. 185
Reviewp. 186
Dates: Then, Now, and the Differencep. 189
Date Arithmeticp. 190
Round and Trunc in Data Calculationsp. 199
To_Date and To_Char Formattingp. 200
Dates in where Clausesp. 211
Dealing with Multiple Centuriesp. 212
Using the Extract Functionp. 213
Using the Timestamp Datatypesp. 214
Conversion and Transformation Functionsp. 217
Elementary Conversion Functionsp. 220
Specialized Conversion Functionsp. 225
Transformation Functionsp. 226
Reviewp. 228
Grouping Things Togetherp. 229
The Use of group by and havingp. 230
Views of Groupsp. 234
The Power of Views of Groupsp. 236
More Grouping Possibilitiesp. 241
When One Query Depends upon Anotherp. 243
Advanced Subqueriesp. 244
Outer Joinsp. 249
Natural and Inner Joinsp. 255
Union, Intersect, and Minusp. 256
Some Complex Possibilitiesp. 261
Complex Groupingsp. 262
Using Temporary Tablesp. 263
Using Rollup, Grouping, and Cubep. 264
Family Trees and connect byp. 268
Changing Data: insert, update, merge, and deletep. 279
Insertp. 280
Rollback, commit, and autocommitp. 283
Multitable Insertsp. 285
Deletep. 289
Updatep. 291
Using the merge Commandp. 293
Decode and Case: if, then, and else in SQLp. 297
If, then, elsep. 298
Replacing Values via Decodep. 301
Decode Within Decodep. 302
Greater Than and Less Than in Decodep. 305
Using Casep. 307
Creating and Managing Tables, Views, Indexes, Clusters, and Sequencesp. 311
Creating a Tablep. 312
Dropping Tablesp. 320
Altering Tablesp. 321
Creating a Table from a Tablep. 326
Creating an Index-Organized Tablep. 327
Using Partitioned Tablesp. 328
Creating a Viewp. 333
Indexesp. 336
Clustersp. 342
Sequencesp. 344
Basic Oracle Securityp. 345
Users, Roles, and Privilegesp. 346
What Users Can Grantp. 353
Granting Limited Resourcesp. 367
Beyond the Basics
Advanced Security-Virtual Private Databasesp. 371
Initial Configurationp. 372
Create an Application Contextp. 373
Create a Logon Triggerp. 375
Create a Security Policyp. 376
Apply the Security Policy to Tablesp. 377
Test VPDp. 378
How to Implement Column-Level VPDp. 379
How to Disable VPDp. 380
How to Use Policy Groupsp. 381
Working with Tablespacesp. 383
Tablespaces and the Structure of the Databasep. 384
Planning Your Tablespace Usagep. 389
Using SQL*Loader to Load Datap. 391
The Control Filep. 392
Starting the Loadp. 394
Control File Syntax Notesp. 398
Managing Data Loadsp. 400
Tuning Data Loadsp. 402
Additional Featuresp. 404
Using Data Pump Export and Importp. 405
Creating a Directoryp. 406
Data Pump Export Optionsp. 406
Starting a Data Pump Export Jobp. 409
Data Pump Import Optionsp. 413
Starting a Data Pump Import Jobp. 416
Accessing Remote Datap. 423
Database Linksp. 424
Using Synonyms for Location Transparencyp. 431
Using the User Pseudo-Column in Viewsp. 432
Dynamic Links: Using the SQL*Plus copy Commandp. 434
Connecting to a Remote Databasep. 435
Using Materialized Viewsp. 437
Functionalityp. 438
Required System Privilegesp. 438
Required Table Privilegesp. 439
Read-Only vs. Updatablep. 439
Create materialized view Syntaxp. 440
Using Materialized Views to Alter Query Execution Pathsp. 445
Using DBMS_ADVISORp. 447
Refreshing Materialized Viewsp. 449
Create materialized view log Syntaxp. 455
Altering Materialized Views and Logsp. 456
Dropping Materialized Views and Logsp. 457
Using Oracle Text for Text Searchesp. 459
Adding Text to the Databasep. 460
Text Queries and Text Indexesp. 461
Index Setsp. 474
Using External Tablesp. 477
Accessing the External Datap. 478
Creating an External Tablep. 479
Altering External Tablesp. 489
Limitations, Benefits, and Potential Uses of External Tablesp. 490
Using Flashback Queriesp. 493
Time-Based Flashback Examplep. 494
Saving the Datap. 496
SCN-Based Flashback Examplep. 497
What If the Flashback Query Fails?p. 499
What SCN Is Associated with Each Row?p. 499
Flashback Version Queriesp. 500
Planning for Flashbacksp. 502
Flashback-Tables and Databasesp. 503
The flashback table Commandp. 504
The flashback database Commandp. 507
An Introduction to PL/SQLp. 513
PL/SQL Overviewp. 514
Declarations Sectionp. 514
Executable Commands Sectionp. 518
Exception Handling Sectionp. 531
Triggersp. 535
Required System Privilegesp. 536
Required Table Privilegesp. 536
Types of Triggersp. 537
Trigger Syntaxp. 538
Enabling and Disabling Triggersp. 548
Replacing Triggersp. 549
Dropping Triggersp. 550
Procedures, Functions, and Packagesp. 555
Required System Privilegesp. 556
Required Table Privilegesp. 558
Procedures vs. Functionsp. 558
Procedures vs. Packagesp. 558
Create procedure Syntaxp. 559
Create function Syntaxp. 561
Create package Syntaxp. 568
Viewing Source Code for Procedural Objectsp. 572
Compiling Procedures, Functions, and Packagesp. 572
Replacing Procedures, Functions, and Packagesp. 573
Dropping Procedures, Functions, and Packagesp. 573
Using Native Dynamic SQL and DBMS_SQLp. 575
Using Bind Variablesp. 578
Using DBMS_SQLp. 579
Object-Relational Databases
Implementing Types, Object Views, and Methodsp. 587
Working with Abstract Datatypesp. 588
Implementing Object Viewsp. 593
Methodsp. 599
Collectors (Nested Tables and Varying Arrays)p. 603
Varying Arraysp. 604
Nested Tablesp. 610
Additional Functions for Nested Tables and Varying Arraysp. 615
Management Issues for Nested Tables and Varying Arraysp. 615
Using Large Objectsp. 619
Available Datatypesp. 620
Specifying Storage for LOB Datap. 621
Manipulating and Selecting LOB Valuesp. 623
Advanced Object-Oriented Conceptsp. 647
Row Objects vs. Column Objectsp. 648
Object Tables and OIDsp. 648
Object Views with REFsp. 656
Object PL/SQLp. 661
Objects in the Databasep. 662
Java in Oracle
An Introduction to Javap. 667
Java vs. PL/SQL: An Overviewp. 668
Getting Startedp. 669
Declarationsp. 669
Executable Commandsp. 670
Classesp. 679
JDBC Programmingp. 685
Getting Startedp. 686
Using the JDBC Classesp. 688
Java Stored Proceduresp. 697
Loading the Class into the Databasep. 700
How to Access the Classp. 702
Clustered Oracle-The Grid
Oracle Real Application Clustersp. 709
Preinstallation Stepsp. 710
Installing RACp. 710
Starting and Stopping RAC Instancesp. 714
Transparent Application Failoverp. 716
Adding Nodes and Instances to the Clusterp. 717
Managing the Cluster Registry and Servicesp. 718
Grid Architecture and Managementp. 719
Hardware and Operating System Configuration Issuesp. 720
Adding Servers to the Gridp. 723
Sharing Data Across the Gridp. 724
Managing the Gridp. 724
Launching OEMp. 726
Hitchhiker's Guides
The Hitchhiker's Guide to the Oracle Data Dictionaryp. 731
A Note About Nomenclaturep. 731
New Views Introduced in Oracle Database 10gp. 733
New Columns Introduced in Oracle Database 10gp. 738
Things You Select From: Tables (and Columns), Views, Synonyms, and Sequencesp. 746
Constraints and Commentsp. 755
Abstract Datatypes, ORDBMS-Related Structures, and LOBsp. 764
Database Links and Materialized Viewsp. 767
Triggers, Procedures, Functions, and Packagesp. 770
Dimensionsp. 773
Space Allocation and Usage, Including Partitions and Subpartitionsp. 774
Users and Privilegesp. 780
Rolesp. 782
Auditingp. 783
Miscellaneousp. 785
Monitoring: The V$ Dynamic Performance Tablesp. 785
The Hitchhiker's Guide to Tuning Applications and SQLp. 791
New Tuning Features in Oracle Database 10gp. 792
Tuning-Best Practicesp. 794
Generating and Reading Explain Plansp. 803
Major Operations Within Explain Plansp. 808
Implementing Stored Outlinesp. 831
Reviewp. 833
Case Studies in Tuningp. 835
Waits, Waits, and More Waitsp. 836
Application-Killing Queriesp. 839
Long-Running Batch Jobsp. 841
The Hitchhiker's Guide to Oracle Application Server 10gp. 845
What Is Oracle Application Server 10g?p. 847
Communication Servicesp. 854
Content Management Servicesp. 859
Business Logic Servicesp. 859
Presentation Servicesp. 861
Business Intelligence Servicesp. 863
Portal Servicesp. 865
Web Servicesp. 866
Developer Toolkitsp. 867
Persistence Layer Servicesp. 872
Caching Servicesp. 874
System Servicesp. 876
Development Toolsp. 878
The Hitchhiker's Guide to Database Administrationp. 885
Creating a Databasep. 886
Starting and Stopping the Databasep. 887
Sizing and Managing Memory Areasp. 888
Allocating and Managing Space for the Objectsp. 891
Monitoring an Undo Tablespacep. 900
Automating Storage Managementp. 901
Segment Space Managementp. 902
Transporting Tablespacesp. 903
Performing Backupsp. 904
Where to Go from Herep. 919
The Hitchhiker's Guide to XML in Oraclep. 921
Document Type Definitions, Elements, and Attributesp. 922
XML Schemap. 926
Using XSU to Select, Insert, Update, and Delete XML Valuesp. 928
Using XML Typep. 934
Other Featuresp. 936
Alphabetical Referencep. 937
Indexp. 1331
Table of Contents provided by Rittenhouse. All Rights Reserved.

ISBN: 9780072253511
ISBN-10: 0072253517
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 1392
Published: 28th September 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.1 x 18.6  x 6.6
Weight (kg): 2.3
Edition Number: 1