List of Examples

2-1 Connecting to Oracle Database from SQL*Plus
2-2 Viewing HR Schema Objects with SQL*Plus
2-3 Viewing EMPLOYEES Table Properties with SQL*Plus
2-4 Viewing EMPLOYEES Table Data with SQL*Plus
2-5 Displaying Selected Columns Under New Headings
2-6 Preserving Case and Including Spaces in Column Aliases
2-7 Selecting Data from One Department
2-8 Selecting Data for Last Names that Start with the Same Substring
2-9 Selecting Data that Satisfies Two Conditions
2-10 Sorting Selected Data by LAST_NAME
2-11 Sorting Selected Data by an Unselected Column
2-12 Selecting Data from Two Tables (Joining Two Tables)
2-13 Using an Arithmetic Expression in a Query
2-14 Rounding Numeric Data
2-15 Truncating Numeric Data
2-16 Concatenating Character Data
2-17 Changing the Case of Character Data
2-18 Displaying the Number of Years Between Dates
2-19 Displaying System Date and Time
2-20 Converting Dates to Characters Using a Format Template
2-21 Converting Characters to Numbers
2-22 Counting the Number of Rows in Each Group
2-23 Limiting Aggregate Functions to Rows that Satisfy a Condition
2-24 Using Aggregate Functions for Statistical Information
2-25 Substituting a String for a NULL Value
2-26 Specifying Different Expressions for NULL and Not NULL Values
2-27 Using a Simple CASE Expression in a Query
2-28 Using a Searched CASE Expression in a Query
2-29 Using the DECODE Function in a Query
3-1 Using the INSERT Statement When All Information Is Available
3-2 Using the INSERT Statement When Not All Information Is Available
3-3 Using the INSERT Statement Incorrectly
3-4 Using the UPDATE Statement to Add Data
3-5 Using the UPDATE Statement to Update Multiple Rows
3-6 Using the DELETE Statement
3-7 Committing a Transaction
3-8 Rolling Back an Entire Transaction
3-9 Rolling Back a Transaction to a Savepoint
4-1 Creating the EVALUATIONS Table with CREATE TABLE
4-2 Creating the SCORES Table with CREATE TABLE
4-3 Creating the EMP_LOCATIONS View with CREATE VIEW
4-4 Changing the Query in the SALESFORCE View
5-1 Assigning Values to a Variable with Assignment Operator
5-2 Assigning Table Values to Variables with SELECT INTO
5-3 Inserting a Table Row with Values from Another Table
5-4 IF Statement that Determines Return Value of Function
5-5 CASE Statement that Determines Which String to Print
5-6 FOR LOOP Statement that Computes Salary After Five Years
5-7 WHILE LOOP Statement that Computes Salary to Maximum
5-8 Using the EXIT WHEN Statement
5-9 Declaring Associative Arrays
5-10 Populating Associative Arrays
5-11 Traversing a Dense Associative Array
5-12 Traversing a Sparse Associative Array
5-13 Handling Predefined Exception NO_DATA_FOUND
5-14 Handling User-Defined Exceptions
6-1 Creating an INSTEAD OF Trigger
7-1 NLS_LANGUAGE Affects Server Message and Month Abbreviations
7-2 NLS_TERRITORY Affects Currency Symbol
7-3 NLS_TERRITORY Affects Date Formats
7-4 NLS_DATE_FORMAT Overrides NLS_TERRITORY
7-5 NLS_DATE_LANGUAGE Affects Displayed SYSDATE
7-6 NLS_CALENDAR Affects Displayed SYSDATE
7-7 NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator
7-8 NLS_CURRENCY Overrides NLS_TERRITORY
7-9 NLS_ISO_CURRENCY
7-10 NLS_SORT Affects Linguistic Sort Order
7-11 NLS_COMP Affects SQL Character Comparison
7-12 NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column
8-1 Bind Variable Improves Performance
8-2 Bulk SQL
8-3 Without Bulk SQL
8-4 Concurrent Dequeuing Transactions