Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to 2 Day Oracle Database Development
-
2
Connecting to Oracle Database and Exploring It
- Connecting to Oracle Database from SQL*Plus
- Connecting to Oracle Database from SQL Developer
- Connecting to Oracle Database as User HR
- Exploring Oracle Database with SQL*Plus
- Exploring Oracle Database with SQL Developer
-
Selecting Table Data
- About Queries
- Running Queries in SQL Developer
- Tutorial: Selecting All Columns of a Table
- Tutorial: Selecting Specific Columns of a Table
- Displaying Selected Columns Under New Headings
- Selecting Data that Satisfies Specified Conditions
- Sorting Selected Data
- Selecting Data from Multiple Tables
-
Using Operators and Functions in Queries
- Using Arithmetic Operators in Queries
- Using Numeric Functions in Queries
- Using the Concatenation Operator in Queries
- Using Character Functions in Queries
- Using Datetime Functions in Queries
- Using Conversion Functions in Queries
- Using Aggregate Functions in Queries
- Using NULL-Related Functions in Queries
- Using CASE Expressions in Queries
- Using the DECODE Function in Queries
- 3 About DML Statements and Transactions
-
4
Creating and Managing Schema Objects
- About Data Definition Language (DDL) Statements
- Creating and Managing Tables
- Creating and Managing Views
- Creating and Managing Sequences
- Creating and Managing Synonyms
-
5
Developing Stored Subprograms and Packages
- About Stored Subprograms
- About Packages
- About PL/SQL Identifiers
- About PL/SQL Data Types
- Creating and Managing Standalone Subprograms
- Creating and Managing Packages
- Declaring and Assigning Values to Variables and Constants
- Controlling Program Flow
-
Using Records and Cursors
- About Records
- Tutorial: Declaring a RECORD Type
- Tutorial: Creating and Invoking a Subprogram with a Record Parameter
- About Cursors
- Using a Declared Cursor to Retrieve Result Set Rows One at a Time
- Tutorial: Using a Declared Cursor to Retrieve Result Set Rows One at a Time
- About Cursor Variables
- Using a Cursor Variable to Retrieve Result Set Rows One at a Time
- Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time
- Using Associative Arrays
- Handling Exceptions (Runtime Errors)
- 6 Using Triggers
-
7
Working in a Global Environment
- About Globalization Support Features
- About Initial NLS Parameter Values
- Viewing NLS Parameter Values
- Changing NLS Parameter Values
-
About Individual NLS Parameters
- About Locale and the NLS_LANG Parameter
- About the NLS_LANGUAGE Parameter
- About the NLS_TERRITORY Parameter
- About the NLS_DATE_FORMAT Parameter
- About the NLS_DATE_LANGUAGE Parameter
- About NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters
- About the NLS_CALENDAR Parameter
- About the NLS_NUMERIC_CHARACTERS Parameter
- About the NLS_CURRENCY Parameter
- About the NLS_ISO_CURRENCY Parameter
- About the NLS_DUAL_CURRENCY Parameter
- About the NLS_SORT Parameter
- About the NLS_COMP Parameter
- About the NLS_LENGTH_SEMANTICS Parameter
- Using Unicode in Globalized Applications
-
8
Building Effective Applications
- Building Scalable Applications
- Recommended Programming Practices
- Recommended Security Practices
-
9
Developing a Simple Oracle Database Application
- About the Application
- Creating the Schemas for the Application
- Granting Privileges to the Schemas
- Creating the Schema Objects and Loading the Data
- Creating the employees_pkg Package
- Creating the admin_pkg Package
-
10
Deploying an Oracle Database Application
- About Development and Deployment Environments
- About Installation Scripts
- Creating Installation Scripts
- Deploying the Sample Application
- Checking the Validity of an Installation
- Archiving the Installation Scripts
- Index