Oracle Database 10g SQL (Osborne ORACLE Press Series)
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 217
Pages: 217
Authors: Jason Price, McGraw-Hill
- Table of Contents
- BackCover
- Oracle Database 10g SQL
- Introduction
- Intended Audience
- Retrieving the Examples
- Chapter 1: Introduction
- What Is a Relational Database?
- Introducing the Structured Query Language (SQL)
- Using SQLPlus
- Performing a SELECT Statement Using SQLPlus
- The SQLPlus Worksheet
- Creating the Store Schema
- Adding, Modifying, and Removing Rows
- Modifying an Existing Row in a Table
- Removing a Row from a Table
- The New Oracle10g BINARY_FLOAT and BINARY_DOUBLE Types
- Quitting SQLPlus
- Introducing Oracle PLSQL
- Summary
- Chapter 2: Retrieving Information from Database Tables
- Performing Single Table SELECT Statements
- Selecting All Columns from a Table
- Understanding Row Identifiers
- Performing Arithmetic
- Using Column Aliases
- Merging Column Output Using Concatenation
- Understanding Null Values
- Displaying Distinct Rows
- Filtering Rows Using the WHERE Clause
- Sorting Rows Using the ORDER BY Clause
- Performing SELECT Statements that Use Two Tables
- Supplying Table Aliases
- Cartesian Products
- Performing SELECT Statements that Use More than Two Tables
- Understanding Join Conditions and Join Types
- Performing Joins Using the SQL92 Syntax
- Summary
- Chapter 3: Using Simple Functions
- Using Single Row Functions
- Using Aggregate Functions
- Grouping Rows
- Summary
- Chapter 4: Storing and Processing Dates and Times
- Simple Examples of Storing and Retrieving Dates
- Converting Datetimes Using TO_CHAR() and TO DATE()
- Setting the Default Date Format
- How Oracle Interprets Two-Digit Years
- Using Datetime Functions
- Understanding Time Zones
- Using Timestamps
- Using Time Intervals
- Summary
- Chapter 5: Using SQLPlus
- Viewing the Structure of a Table
- Editing SQL Statements
- Saving, Retrieving, and Running Files
- Formatting Columns
- Setting the Page Size
- Setting the Line Size
- Clearing Column Formatting
- Using Variables
- Creating Simple Reports
- Automatically Generating SQL Statements
- Summary
- Chapter 6: Subqueries
- Types of Subqueries
- Writing Single Row Subqueries
- Writing Multiple Row Subqueries
- Writing Multiple Column Subqueries
- Writing Correlated Subqueries
- Writing Nested Subqueries
- Writing UPDATE and DELETE Statements Containing Subqueries
- Summary
- Chapter 7: Advanced Queries
- Using the Set Operators
- Using the TRANSLATE() Function
- Using the DECODE() Function
- Using the CASE Expression
- Hierarchical Queries
- Using the Extended GROUP BY Clauses
- Using the ROLLUP Clause
- Using the Analytic Functions
- Using the MODEL Clause
- Summary
- Chapter 8: Changing Table Contents
- Modifying Rows Using the UPDATE Statement
- Removing Rows Using the DELETE Statement
- Database Integrity
- Using Default Values
- Merging Rows Using MERGE
- Database Transactions
- Query Flashbacks
- Summary
- Chapter 9: Database Security
- System Privileges
- Object Privileges
- Roles
- Summary
- Chapter 10: Creating Tables, Sequences, Indexes, and Views
- Tables
- Sequences
- Indexes
- Views
- Summary
- Chapter 11: Introducing PLSQL Programming
- Block Structure
- Variables and Types
- Conditional Logic
- Loops
- Cursors
- Exceptions
- Procedures
- Functions
- Packages
- Triggers
- Summary
- Chapter 12: Database Objects
- Introducing Objects
- Creating Object Types
- Using DESCRIBE to Get Information on Object Types
- Using Object Types to Define Column Objects and Object Tables
- Performing DML on the products Table
- Performing DML on the object_products Table
- Performing DML on the object_customers Table
- Performing DML on the purchases Table
- Using Objects in PLSQL
- Type Inheritance
- NOT INSTANTIABLE Object Types
- User-Defined Constructors
- Summary
- Chapter 13: Collections
- Varrays
- Nested Tables
- Multilevel Collection Types
- Using Collections in PLSQL
- Oracle10g Enhancements to Collections
- Summary
- Chapter 14: Large Objects
- The Example Files
- Understanding the Large Object Types
- Creating Tables Containing Large Objects
- Using Large Objects in SQL
- Using Large Objects in PLSQL
- Understanding the LONG and LONG RAW Types
- Oracle Database 10g Enhancements to Large Objects
- Summary
- Chapter 15: Running SQL Using Java
- Configuring Your Computer
- The Oracle JDBC Drivers
- Importing the JDBC Packages
- Registering the Oracle JDBC Drivers
- Opening a Database Connection
- Creating a JDBC Statement Object
- Retrieving Rows from the Database
- Adding Rows to the Database
- Modifying Rows in the Database
- Deleting Rows from the Database
- Handling Numbers
- Handling Database Null Values
- Controlling Database Transactions
- Performing Data Definition Language Statements
- Handling Exceptions
- Closing Your JDBC Objects
- Example Program: BasicExample1.java
- Prepared SQL Statements
- Example Program: BasicExample2.java
- The Oracle JDBC Extensions
- Summary
- Chapter 16: High Performance SQL Tuning
- Use a WHERE Clause to Filter Rows
- Use Table Joins Rather than Multiple Queries
- Use Fully Qualified Column References When Performing Joins
- Use CASE Expressions Rather than Multiple Queries
- Add Indexes to Tables
- Use WHERE Rather than HAVING
- Use UNION ALL Rather than UNION
- Use EXISTS Rather than IN
- Use EXISTS Rather than DISTINCT
- Use Bind Variables
- Comparing the Cost of Performing Queries
- Passing Hints to the Optimizer
- Additional Tuning Tools
- Summary
- Appendix: Oracle Data Types
- Oracle PLSQL Types
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- Index_Y
- Index_Z
- List of Figures
- List of Tables
- List of Sidebars
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 217
Pages: 217
Authors: Jason Price, McGraw-Hill