Oracle database 12c : the complete reference / Bob Bryla, Kevin Loney.

Format:

Book

Author/Creator:

Bryla, Bob, author.

Loney, Kevin, author.

Language:

English

Subjects (All):

Database management.

Relational databases.

Oracle (Computer file).

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

1st edition

Place of Publication:

New York, New York State : McGraw-Hill Education, 2014.

System Details:

text file

Summary:

"Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions"-- Provided by publisher.

Contents:

Cover

About the Authors

Title Page

Copyright Page

Contents

Acknowledgments

Part I: Critical Database Concepts

1 Oracle Database 12c Architecture Options

Databases and Instances

Inside the Database

Choosing Architectures and Options

2 Installing Oracle Database 12c and Creating a Database

Overview of Licensing and Installation Options

Installing the Oracle Software

3 Upgrading to Oracle Database 12c

Choosing an Upgrade Method

Before Upgrading

Upgrading the Grid Infrastructure and Database

After Upgrading

4 Planning Oracle Applications-Approaches, Risks, and Standards

The Cooperative Approach

Everyone Has "Data"

The Familiar Language of Oracle

Some Common, Everyday Examples

What Are the Risks?

The Importance of the New Vision

How to Reduce the Confusion

Capitalization in Names and Data

Normalizing Names

Good Design Has a Human Touch

Understanding the Data

Toward Object Name Normalization

Intelligent Keys and Column Values

The Commandments

Part II: SQL and SQL*Plus

5 The Basic Parts of Speech in SQL

Style

Creating the NEWSPAPER Table

Using SQL to Select Data from Tables

SELECT, FROM, WHERE, and ORDER BY

Logic and Value

Another Use for WHERE: Subqueries

Combining Tables

Creating a View

Expanding the View

6 Basic SQL*Plus Reports and Commands

Building a Simple Report

Other Features

Checking the SQL*Plus Environment

Building Blocks

7 Getting Text Information and Changing It

Datatypes

What Is a String?

Notation

Concatenation ( || )

How to Cut and Paste Strings

Using ORDER BY and WHERE with String Functions

Review

8 Searching for Regular Expressions

Search Strings

REGEXP_SUBSTR

9 Playing the Numbers

The Three Classes of Number Functions

Notation.

Single-Value Functions

Aggregate Functions

List Functions

Finding Rows with MAX or MIN

Precedence and Parentheses

10 Dates: Then, Now, and the Difference

Date Arithmetic

SYSDATE, CURRENT_DATE, and SYSTIMESTAMP

ROUND and TRUNC in Date Calculations

TO_DATE and TO_CHAR Formatting

Dates in WHERE Clauses

Dealing with Multiple Centuries

Using the EXTRACT Function

Using the TIMESTAMP Datatypes

11 Conversion and Transformation Functions

Elementary Conversion Functions

Specialized Conversion Functions

Transformation Functions

12 Grouping Things Together

Using GROUP BY and HAVING

Views of Groups

Renaming Columns with Aliases

The Power of Views of Groups

More Grouping Possibilities

13 When One Query Depends on Another

Advanced Subqueries

Outer Joins

Natural and Inner Joins

UNION, INTERSECT, and MINUS

14 Some Complex Possibilities

Complex Groupings

Using Temporary Tables

Using ROLLUP, GROUPING, and CUBE

Family Trees and CONNECT BY

15 Changing Data: INSERT, DELETE, UPDATE and MERGE

INSERT

ROLLBACK, COMMIT, and AUTOCOMMIT

Multitable INSERTs

DELETE

UPDATE

MERGE

Handling Errors

16 DECODE and CASE: IF, THEN, and ELSE in SQL

IF, THEN, ELSE

Replacing Values via DECODE

DECODE Within DECODE

Greater Than and Less Than in DECODE

Using CASE

Using PIVOT

17 Creating and Managing Tables, Views, Indexes, Clusters, and Sequences

Creating a Table

Dropping Tables

Altering Tables

Creating a Table from a Table

Creating an Index-Organized Table

Indexes

Clusters

Sequences

18 Partitioning

Creating a Partitioned Table

List Partitioning

Creating Subpartitions

Creating Reference and Interval Partitions

Indexing Partitions

Managing Partitioned Tables.

19 Basic Oracle Security

Users, Roles, and Privileges

What Users Can Grant

Granting Access to Limited Resources

Part III: Beyond the Basics

20 Advanced Security-Virtual Private Databases

Initial Configuration

Create an Application Context

Create a Logon Trigger

Create a Security Policy

Apply the Security Policy to Tables

Test the VPD Security Policy

How to Implement Column-Level VPD

How to Disable VPD

How to Use Policy Groups

21 Advanced Security-Transparent Data Encryption

Transparent Data Encryption for Columns

Transparent Data Encryption for Tablespaces

22 Working with Tablespaces

Tablespaces and the Structure of the Database

Planning Your Tablespace Usage

23 Using SQL*Loader to Load Data

The Control File

Starting the Load

Logical and Physical Records

Control File Syntax Notes

Managing Data Loads

Repeating Data Loads

Tuning Data Loads

Direct Path Loading

SQL*Loader Express Mode

Additional Features

24 Using Data Pump Export and Import

Creating a Directory

Data Pump Export Options

Starting a Data Pump Export Job

Data Pump Import Options

Starting a Data Pump Import Job

25 Accessing Remote Data

Database Links

Using Synonyms for Location Transparency

Using the USER Pseudo-Column in Views

26 Using Materialized Views

Functionality

Required System Privileges

Required Table Privileges

Read-Only vs. Updatable

CREATE MATERIALIZED VIEW Syntax

Using Materialized Views to Alter Query Execution Paths

Using DBMS_ADVISOR

Refreshing Materialized Views

CREATE MATERIALIZED VIEW Log Syntax

Altering Materialized Views and Logs

Dropping Materialized Views and Logs

27 Using Oracle Text for Text Searches

Adding Text to the Database

Text Queries and Text Indexes

Index Sets

28 Using External Tables.

Accessing the External Data

Creating an External Table

Altering External Tables

Limitations, Benefits, and Potential Uses of External Tables

29 Using Flashback Queries

Time-Based Flashback Example

Saving the Data

SCN-Based Flashback Example

What If the Flashback Query Fails?

What SCN Is Associated with Each Row?

Flashback Version Queries

Planning for Flashbacks

30 Flashback-Tables and Databases

The FLASHBACK TABLE Command

The FLASHBACK DATABASE Command

31 SQL Replay

High-level Configuration

Capturing the Workload

Processing the Workload

Replaying the Workload

Part IV: PL/SQL

32 An Introduction to PL/SQL

PL/SQL Overview

Declarations Section

Executable Commands Section

Exception Handling Section

33 Online Application Upgrades

Highly Available Databases

Making Low-Impact DDL Changes

34 Triggers

Types of Triggers

Trigger Syntax

Enabling and Disabling Triggers

Replacing Triggers

Dropping Triggers

35 Procedures, Functions, and Packages

Procedures vs. Functions

Procedures vs. Packages

CREATE PROCEDURESyntax

CREATE FUNCTIONSyntax

CREATE PACKAGE Syntax

Viewing Source Code for Procedural Objects

Compiling Procedures, Functions, and Packages

Replacing Procedures, Functions, and Packages

Dropping Procedures, Functions, and Packages

36 Using Native Dynamic SQL and DBMS_SQL

Using EXECUTE IMMEDIATE

Using Bind Variables

Using DBMS_SQL

37 PL/SQL Tuning

Tune the SQL

Steps for Tuning the PL/SQL

Use PL/SQL Within SQL Statements

Use DBMS_PROFILER to Identify Problems

Use PL/SQL Features for Bulk Operations

Part V: Object-Relational Databases.

38 Implementing Object Types, Object Views, and Methods

Working with Object Types

Implementing Object Views

Methods

39 Collectors (Nested Tables and Varying Arrays)

Varying Arrays

Nested Tables

Additional Functions for Nested Tables and Varying Arrays

Management Issues for Nested Tables and Varying Arrays

40 Using Large Objects

Available Datatypes

Specifying Storage for LOB Data

Manipulating and Selecting LOB Values

41 Advanced Object-Oriented Concepts

Row Objects vs. Column Objects

Object Tables and OIDs

Object Views with REFs

Object PL/SQL

Objects in the Database

Part VI: Java in Oracle

42 An Introduction to Java

Java vs. PL/SQL: An Overview

Getting Started

Declarations

Executable Commands

Classes

43 JDBC Programming

Using the JDBC Classes

Using JDBC for Data Manipulation

44 Java Stored Procedures

Loading the Class into the Database

How to Access the Clas

Part VII: Hitchhiker's Guides

45 The Hitchhiker's Guide to the Oracle Data Dictionary

A Note about Nomenclature

New Views Introduced in Oracle Database 12c

New Views Introduced in Oracle Database 11g

The Road Maps: DICTIONARY (DICT) and DICT_COLUMNS

Things You Select From: Tables (and Columns), Views, Synonyms, and Sequences

Recycle Bin: USER_RECYCLEBIN and DBA_RECYCLEBIN

Constraints and Comments

Indexes and Clusters

Abstract Datatypes and LOBs

Database Links and Materialized Views

Triggers, Procedures, Functions, and Packages

Dimensions

Space Allocation and Usage, Including Partitions and Subpartitions

Users and Privileges

Roles

Auditing

Miscellaneous

46 The Hitchhiker's Guide to Tuning Applications and SQL

An Overview of Oracle Database Tuning Features

Tuning-Best Practices

Generating and Reading Explain Plans.

Major Operations Within Explain Plans.

Notes:

Includes index.

"Administer and secure a robust Cloud-based environment"--Cover.

Description based on print version record.

ISBN:

9780071801744

007180174X

OCLC:

911187168