Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to 2 Day Oracle Database Development
- 1.1 About This Document
-
1.2
About Oracle Database
- 1.2.1 About Schema Objects
-
1.2.2
About Oracle Database Access
- 1.2.2.1 About SQL*Plus
- 1.2.2.2 About SQL Developer
- 1.2.2.3 About Structured Query Language (SQL)
- 1.2.2.4 About Procedural Language/SQL (PL/SQL)
-
1.2.2.5
About Other Client Programs, Languages, and Development Tools
- 1.2.2.5.1 Oracle Application Express
- 1.2.2.5.2 Oracle Java Database Connectivity (JDBC)
- 1.2.2.5.3 Hypertext Preprocessor (PHP)
- 1.2.2.5.4 Oracle Call Interface (OCI)
- 1.2.2.5.5 Oracle C++ Call Interface (OCCI)
- 1.2.2.5.6 Open Database Connectivity (ODBC)
- 1.2.2.5.7 Pro*C/C++ Precompiler
- 1.2.2.5.8 Pro*COBOL Precompiler
- 1.2.2.5.9 Microsoft .NET Framework
- 1.2.2.5.10 Oracle Provider for OLE DB (OraOLEDB)
- 1.3 About Sample Schema HR
-
2
Connecting to Oracle Database and Exploring It
- 2.1 Connecting to Oracle Database from SQL*Plus
- 2.2 Connecting to Oracle Database from SQL Developer
- 2.3 Connecting to Oracle Database as User HR
- 2.4 Exploring Oracle Database with SQL*Plus
- 2.5 Exploring Oracle Database with SQL Developer
-
2.6
Selecting Table Data
- 2.6.1 About Queries
- 2.6.2 Running Queries in SQL Developer
- 2.6.3 Tutorial: Selecting All Columns of a Table
- 2.6.4 Tutorial: Selecting Specific Columns of a Table
- 2.6.5 Displaying Selected Columns Under New Headings
- 2.6.6 Selecting Data that Satisfies Specified Conditions
- 2.6.7 Sorting Selected Data
- 2.6.8 Selecting Data from Multiple Tables
-
2.6.9
Using Operators and Functions in Queries
- 2.6.9.1 Using Arithmetic Operators in Queries
- 2.6.9.2 Using Numeric Functions in Queries
- 2.6.9.3 Using the Concatenation Operator in Queries
- 2.6.9.4 Using Character Functions in Queries
- 2.6.9.5 Using Datetime Functions in Queries
- 2.6.9.6 Using Conversion Functions in Queries
- 2.6.9.7 Using Aggregate Functions in Queries
- 2.6.9.8 Using NULL-Related Functions in Queries
- 2.6.9.9 Using CASE Expressions in Queries
- 2.6.9.10 Using the DECODE Function in Queries
- 3 About DML Statements and Transactions
-
4
Creating and Managing Schema Objects
- 4.1 About Data Definition Language (DDL) Statements
-
4.2
Creating and Managing Tables
- 4.2.1 About SQL Data Types
- 4.2.2 Creating Tables
- 4.2.3 Ensuring Data Integrity in Tables
- 4.2.4 Tutorial: Adding Rows to Tables with the Insert Row Tool
- 4.2.5 Tutorial: Changing Data in Tables in the Data Pane
- 4.2.6 Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool
- 4.2.7 Managing Indexes
- 4.2.8 Dropping Tables
- 4.3 Creating and Managing Views
- 4.4 Creating and Managing Sequences
- 4.5 Creating and Managing Synonyms
-
5
Developing Stored Subprograms and Packages
- 5.1 About Stored Subprograms
- 5.2 About Packages
- 5.3 About PL/SQL Identifiers
- 5.4 About PL/SQL Data Types
- 5.5 Creating and Managing Standalone Subprograms
- 5.6 Creating and Managing Packages
- 5.7 Declaring and Assigning Values to Variables and Constants
- 5.8 Controlling Program Flow
-
5.9
Using Records and Cursors
- 5.9.1 About Records
- 5.9.2 Tutorial: Declaring a RECORD Type
- 5.9.3 Tutorial: Creating and Invoking a Subprogram with a Record Parameter
- 5.9.4 About Cursors
- 5.9.5 Using a Declared Cursor to Retrieve Result Set Rows One at a Time
- 5.9.6 Tutorial: Using a Declared Cursor to Retrieve Result Set Rows One at a Time
- 5.9.7 About Cursor Variables
- 5.9.8 Using a Cursor Variable to Retrieve Result Set Rows One at a Time
- 5.9.9 Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time
- 5.10 Using Associative Arrays
- 5.11 Handling Exceptions (Runtime Errors)
- 6 Using Triggers
-
7
Working in a Global Environment
-
7.1
About Globalization Support Features
- 7.1.1 About Language Support
- 7.1.2 About Territory Support
- 7.1.3 About Date and Time Formats
- 7.1.4 About Calendar Formats
- 7.1.5 About Numeric and Monetary Formats
- 7.1.6 About Linguistic Sorting and String Searching
- 7.1.7 About Length Semantics
- 7.1.8 About Unicode and SQL National Character Data Types
- 7.2 About Initial NLS Parameter Values
- 7.3 Viewing NLS Parameter Values
- 7.4 Changing NLS Parameter Values
-
7.5
About Individual NLS Parameters
- 7.5.1 About Locale and the NLS_LANG Parameter
- 7.5.2 About the NLS_LANGUAGE Parameter
- 7.5.3 About the NLS_TERRITORY Parameter
- 7.5.4 About the NLS_DATE_FORMAT Parameter
- 7.5.5 About the NLS_DATE_LANGUAGE Parameter
- 7.5.6 About NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters
- 7.5.7 About the NLS_CALENDAR Parameter
- 7.5.8 About the NLS_NUMERIC_CHARACTERS Parameter
- 7.5.9 About the NLS_CURRENCY Parameter
- 7.5.10 About the NLS_ISO_CURRENCY Parameter
- 7.5.11 About the NLS_DUAL_CURRENCY Parameter
- 7.5.12 About the NLS_SORT Parameter
- 7.5.13 About the NLS_COMP Parameter
- 7.5.14 About the NLS_LENGTH_SEMANTICS Parameter
- 7.6 Using Unicode in Globalized Applications
-
7.1
About Globalization Support Features
-
8
Building Effective Applications
-
8.1
Building Scalable Applications
- 8.1.1 About Scalable Applications
- 8.1.2 Using Bind Variables to Improve Scalability
- 8.1.3 Using PL/SQL to Improve Scalability
- 8.1.4 About Concurrency and Scalability
- 8.1.5 Limiting the Number of Concurrent Sessions
- 8.1.6 Comparing Programming Techniques with Runstats
- 8.1.7 Real-World Performance and Data Processing Techniques
- 8.2 Recommended Programming Practices
- 8.3 Recommended Security Practices
-
8.1
Building Scalable Applications
-
9
Developing a Simple Oracle Database Application
- 9.1 About the Application
- 9.2 Creating the Schemas for the Application
- 9.3 Granting Privileges to the Schemas
- 9.4 Creating the Schema Objects and Loading the Data
-
9.5
Creating the employees_pkg Package
- 9.5.1 Creating the Package Specification for employees_pkg
- 9.5.2 Creating the Package Body for employees_pkg
- 9.5.3 Tutorial: Showing How the employees_pkg Subprograms Work
- 9.5.4 Granting the Execute Privilege to app_user and app_admin_user
- 9.5.5 Tutorial: Invoking get_job_history as app_user or app_admin_user
- 9.6 Creating the admin_pkg Package
-
10
Deploying an Oracle Database Application
- 10.1 About Development and Deployment Environments
- 10.2 About Installation Scripts
-
10.3
Creating Installation Scripts
- 10.3.1 Creating Installation Scripts with the Cart
- 10.3.2 Creating an Installation Script with the Database Export Wizard
- 10.3.3 Editing Installation Scripts that Create Sequences
- 10.3.4 Editing Installation Scripts that Create Triggers
- 10.3.5 Creating Installation Scripts for the Sample Application
- 10.4 Deploying the Sample Application
- 10.5 Checking the Validity of an Installation
- 10.6 Archiving the Installation Scripts
- Index