List of Examples

• 2-1 Connecting to Oracle Database from SQL*Plus
• 4-1 Displaying Selected Columns Under New Headings
• 4-2 Preserving Case and Including Spaces in Column Aliases
• 4-3 Selecting Data from One Department
• 4-4 Selecting Data from Specified Departments
• 4-5 Selecting Data for Last Names that Start with the Same Substring
• 4-6 Selecting Data for Last Names that Include the Same Substring
• 4-7 Selecting Data that Satisfies Two Conditions
• 4-8 Selecting All Managers in the EMPLOYEES Table
• 4-9 Selecting All Employees Whose Last Names Have Double Vowels
• 4-10 Displaying Phone Numbers in a Different Format
• 4-11 Extracting the Street Number from Each STREET_ADDRESS
• 4-12 Counting the Number of Spaces in Each STREET_ADDRESS
• 4-13 Reporting the Position of the First Space in Each STREET_ADDRESS
• 4-14 Sorting Selected Data by LAST_NAME
• 4-15 Sorting Selected Data by an Unselected Column
• 4-16 Selecting Data from Two Tables (Joining Two Tables)
• 4-17 Using an Arithmetic Expression in a Query
• 4-18 Rounding Numeric Data
• 4-19 Truncating Numeric Data
• 4-20 Concatenating Character Data
• 4-21 Changing the Case of Character Data
• 4-22 Trimming Character Data
• 4-23 Padding Character Data
• 4-24 Extracting Substrings from Character Data
• 4-25 Replacing Substrings in Character Data
• 4-26 Displaying the Number of Months Between Dates
• 4-27 Displaying the Number of Years Between Dates
• 4-28 Displaying the Last Day of a Selected Month
• 4-29 Displaying a Date Six Months from a Selected Date
• 4-30 Displaying System Date and Time
• 4-31 Converting Dates to Characters Using a Format Template
• 4-32 Converting Dates to Characters Using Standard Formats
• 4-33 Converting Numbers to Characters Using a Format Template
• 4-34 Converting Characters to Numbers
• 4-35 Converting a Character String to a Date
• 4-36 Converting a Character String to a Time Stamp
• 4-37 Counting the Number of Rows in Each Group
• 4-38 Counting the Number of Distinct Values in a Set
• 4-39 Using Aggregate Functions for Statistical Information
• 4-40 Limiting Aggregate Functions to Rows that Satisfy a Condition
• 4-41 Showing the Rank and Percentile of a Number Within a Group
• 4-42 Showing the Dense Rank of a Number Within a Group
• 4-43 Substituting a String for a NULL Value
• 4-44 Specifying Different Expressions for NULL and Not NULL Values
• 4-45 Using a CASE Expression in a Query
• 4-46 Using the DECODE Function in a Query
• 5-1 Using the INSERT Statement When All Information Is Available
• 5-2 Using the INSERT Statement When Not All Information Is Available
• 5-3 Using the INSERT Statement Incorrectly
• 5-4 Using the UPDATE Statement to Add Data
• 5-5 Using the UPDATE Statement to Update Multiple Rows
• 5-6 Using the DELETE Statement
• 5-7 Committing a Transaction
• 5-8 Rolling Back an Entire Transaction
• 5-9 Rolling Back a Transaction to a Savepoint
• 6-1 Creating the EVALUATIONS Table with CREATE TABLE
• 6-2 Creating the SCORES Table with CREATE TABLE
• 6-3 Creating the EMP_LOCATIONS View with CREATE VIEW
• 7-1 Assigning Values to a Variable with Assignment Operator
• 7-2 Assigning Table Values to Variables with SELECT INTO
• 7-3 Inserting a Table Row with Values from Another Table
• 7-4 IF Statement that Determines Return Value of Function
• 7-5 CASE Statement that Determines Which String to Print
• 7-6 FOR LOOP Statement that Computes Salary After Five Years
• 7-7 WHILE LOOP Statement that Computes Salary to Maximum
• 7-8 Using the EXIT WHEN Statement
• 7-9 Declaring Associative Arrays
• 7-10 Populating Associative Arrays
• 7-11 Traversing a Dense Associative Array
• 7-12 Traversing a Sparse Associative Array
• 7-13 Handling Predefined Exception NO_DATA_FOUND
• 7-14 Handling User-Defined Exceptions
• 8-1 Creating an INSTEAD OF Trigger
• 9-1 NLS_LANGUAGE Affects Server Message and Month Abbreviations
• 9-2 NLS_TERRITORY Affects Currency Symbol
• 9-3 NLS_TERRITORY Affects Date Formats
• 9-4 NLS_DATE_FORMAT Overrides NLS_TERRITORY
• 9-5 NLS_DATE_LANGUAGE Affects Displayed SYSDATE
• 9-6 NLS_CALENDAR Affects Displayed SYSDATE
• 9-7 NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator
• 9-8 NLS_CURRENCY Overrides NLS_TERRITORY
• 9-9 NLS_ISO_CURRENCY
• 9-10 NLS_SORT Affects Linguistic Sort Order
• 9-11 NLS_COMP Affects SQL Character Comparison
• 9-12 NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column