Oracle SQL Book

Realistic Software Training

Author / Training Specialist / Developer

Oracle SQL & PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Posted Questions and Answers
 
 
 
 
 
 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

As a service to the readers of my book, I will post corrections, suggestions, or answers to any submitted question. 

                                       To submit a question, press this button and  fill out the form.

 

If you do not have any questions but would like to comment on the book, I would enjoy receiving them.  Please fill out the form or send me an e-mail.

I also offer an on-site course based upon this book.  The course can cover all portions of the book or selected parts.  Please contact me for more details or check out my Oracle course listing page.

Locate the page that pertains to your question and click the link.

Chapter
Title
PAGES
 
 Introduction - Installing the database - 2 updates
1
 Understanding Relational Database: The Entity Relationship Diagram, Data Schema Diagram, and Normalization
2
 Building the Database with the Data Definition Language - 1 Correction
3
 The Data Control and Data Manipulation Languages and the Data Dictionary
4
 Retrieving Database Records Using SQL - The Select, Where, and Order By Clauses
5
 Retrieve Records Using SQL - The From, Group By, and Having Clauses
6
 Creating New Values with Character Functions
7
 Creating New Values with Numeric and Date Functions - 2 Correction
8
 Using Set Operators, Subqueries, and Variables
9
 Analytical Processing with SQL
10
 Using Database and Materialized Views
11
 Using SQL*Plus as a Report Writing Tool
12
 What Can You Do if Your SQL Does Not Perform
13
 Using Business Objects
14
 The Basics of PL/SQL - 1 Correction
15
 Handling Exceptions, Using Named Procedures - 1 Correction
16
 Advanced PL/SQL Topics
  Appendix A. Glossary
  Appendix B. Answers - 1 Correction