search for books and compare prices
Tables of Contents for A Guide to Oracle 8
Chapter/Section Title
Page #
Page Count
A Guide to Oracle8 Preface
xi
Read This Before You Begin
xv
An Introduction to Client/Server Databases
1
24
Database Systems
2
1
Personal and client/Server Databases
3
4
The Oracle8 Environment
7
1
Overview of Relational Databases
8
4
The Case Study Databases
12
1
The Clearwater Traders Sales Order Database
12
5
The Northwoods University Student Registration Database
17
4
Summary
21
1
Review Questions
22
3
Creating and Modifying Database Tables
25
36
Table Names and Properties
26
1
Data Types
26
6
Varchar2, Char, Nchar, and Long Character Data Types
27
1
Number Data Types
28
1
Date Data Type
29
1
Large Object Data Types
29
1
Format Masks
30
2
Integtrity Constraints
32
2
Value Constraints
34
2
Starting SQL Plus
36
1
Creating a Database Table Using SQL Plus
37
2
Editing and debugging SQL Commands
39
3
Online Editing in SQL Plus
39
2
Using an Alternate Text Editor with SQL Plus
41
1
Using Online Help
42
5
Exiting SQL Plus
47
1
Spooling SQL Plus Commands and Output to a File
47
3
Viewing Table Structure Information Using SQL Plus
50
2
Viewing Field Definitions
50
1
Viewing Constraint Information
51
1
Modifying Tables Using SQL Plus
52
9
Dropping and Renaming Existing Tables
52
1
Adding Fields to Existing Tables
53
1
Modifying Existing Fields
53
2
Summary
55
2
Review Questions
57
1
Problem-Solving Cases
58
3
Using Oracle to Add, View, and Update Data
61
90
Lesson A
62
16
Running a SQL Script
62
1
Using SQL Plus to Insert Data
63
5
Creating Transactions and Committing New Data
68
2
Updating Existing Records in a Table
70
3
Deleting Records
73
2
Summary
75
1
Review Questions
76
1
Problem-Solving Cases
76
2
Lesson B
78
29
Retrieving Data from a Single Table
78
3
Writing Queries that Retrieve Specific Records
81
6
Sorting the Query Output
87
2
Using Calculations in a Query
89
3
Using Number Functions in a Query
92
1
Creating a Column Alias
93
1
Using Date Arithmetic
94
4
Using Group Functions in Queries
98
4
Summary
102
1
Review Questions
103
1
Problem Solving Cases
104
3
Lesson C
107
44
Using Queries to Join Multiple Tables
107
4
Using Set Operators to Combine Query Results
111
1
Union and Union All
112
3
Intersect
115
1
Minus
116
1
Selecting Records for Update
117
2
Database Views
119
3
Granting Table Privileges to Other Users
122
2
Revoking Table Privileges
124
1
Sequences
124
1
Creating New Sequences
125
2
Accessing the Next Sequence Value
127
4
Accessing the Current Sequence Value
131
2
Granting Sequence Privileges to Other Users
133
1
Viewing and Deleting Sequences
133
2
Using Oracle Query Builder to Retrieve Data
135
1
Creating a Query Using Query Builder
136
4
Viewing the SQL Command Code
140
2
Saving Your query Builder Query
142
1
Other Query Builder Functions
143
4
Summary
147
1
Review Questions
148
1
Problem Solving Cases
149
2
Introduction to PL/SQL, Triggers, and Procedure Builder
151
122
Lesson A
152
31
PL/SQL Variables and Data Types
152
2
PL/SQL Program, Blocks
154
1
PL/SQL Arithmetic Operators
155
1
PL/SQL Assignment Statements
155
1
PL/SQL Interactive Output
156
1
Writing a PL/SQL Program
156
2
Data Type Conversion Functions
158
1
Handling Character Strings
159
1
Concatenating Character Strings
159
2
Placing String Output on a New Line
161
1
Removing Blank Trailing Spaces from Strings
161
1
Finding the Length of Character Strings
161
1
Character String Case Functions
162
1
The INSTR and SUBSTR String Functions
163
1
Debugging PL/SQL programs
164
1
Syntax Errors
165
5
Logic Errors
170
2
The PL/SQL Selection Structure
172
1
The If/Then Structure
173
2
The If/Then/Else Structure
175
1
Nesting If/Then/Else Statements
176
1
The If/Elseif Structure
177
1
Summary
178
1
Review Questions
179
1
Problem Solving Cases
180
3
Lesson B
183
35
Using SQL Commands in PL/SQL Programs
183
2
Loops
185
1
The Loop...Exit Loop
186
1
The Loop...Exit When Loop
187
1
The While...Loop Loop
188
1
The Numeric For Loop
189
1
Cursors
190
3
Declaring an Explicit Cursor
193
1
Opening an Explicit Cursor
194
1
Fetching Data into an Explicit Cursor
194
2
Closing the Cursor
196
1
Processing an Explicit Cursor
196
2
Other Explicit Cursor Attributes
198
3
Handling Exceptions in PL/SQL Programs
201
2
Predefined Exceptions
203
4
Undefined Exceptions
207
2
User-Define Exceptions
209
2
Summary
211
2
Review Questions
213
1
Problem Solving Cases
214
4
Lesson C
218
55
Procedures and Functions in PL/SQL
218
1
Procedures
218
2
Using Oracle Procedure Builder
220
2
Creating a New Procedure
222
4
Correcting Compile Errors
226
2
Running a Procedure
228
2
Using the PL/SQL Interpreter to Find Run-time Errors
230
11
Saving a Program Unit
241
1
Calling a Procedure and Passing Parameters
241
4
Functions
245
4
PL/SQL Libraties
249
3
Stored Program Units
252
1
Packages
253
1
The Package Specification
254
1
The Package Body
255
5
Database Triggers
260
1
Types of Triggers
261
8
Summary
269
1
Review Questions
269
1
Problem Solving Cases
270
3
Creating Oracle Data Block Forms
273
102
Lesson A
274
32
Using a Data Block Form
274
5
Creating the Customer Form
279
7
Running the Form
286
2
Viewing table Records Sequentially
288
1
Viewing Specific Records Using Search Conditions
289
1
Counting Query Hits
290
1
Inserting New Records
290
1
Updating Records
290
1
Deleting Records
291
1
Form components and the Object Navigator
292
7
Changing Object Names in the Object Navigator
299
1
Modifying a Form Using the Data Block Wizard and Layout Wizard
300
2
Summary
302
1
Review Questions
303
1
Problem Solving Cases
304
2
Lesson B
306
32
Creating a Form to Display Multiple records
306
4
Creating a Form Using a Database View
310
4
Modifying Form Properties
314
5
Creating a Multiple-Table Form
319
2
Creating the Cust_Order Detail Data Block
321
4
Running the Master-Detail Form
325
2
Adding Another Detail Data Block to the Form
327
3
Using Format Masks to Format Data fields
330
5
Summary
335
1
Review Questions
335
1
Problem Solving Cases
336
2
Lesson C
338
37
Using Sequences in Forms to Generate Primary Key Values
338
2
Creating Form Triggers
340
3
Debugging Form Triggers
343
4
Testing the Trigger
347
1
Creating a List of Values (LOV)
348
1
Using the LOV Wizard
349
5
Creating the LOV Command Button
354
2
Testing the LOV
356
1
Reformatting the LOV Display
357
1
Displaying Data Using a Radio Button Group
358
10
Enhancing the Form's Appearance
368
2
Summary
370
1
Review Questions
371
1
Problem Solving Cases
371
4
Creating Custom Forms to Support Business Applications
375
118
Lesson A
376
52
The Clearwater Traders Merchandise-Receiving Process
376
2
Creating the Interface Design
378
1
Creating a Custom Form
379
4
Creating the LOV
383
16
Testing the Clearwater Traders Receiving Form
399
1
Using the Form Builder Debugger to Find and Correct Run-Time Errors
400
3
Setting Breakpoints
403
1
Monitoring Program Execution and Variable Values
404
15
Finalizing the Clearwater Traders Receiving Form
419
2
Summary
421
1
Review Questions
421
1
Problem Solving Cases
422
6
Lesson B
428
24
Suppressing System Messages
428
1
Creating Alerts to Provide System Feedback
429
1
Setting Alert Properties
430
1
Display Alerts
431
3
Adding Error Traps
434
3
General Error-Handling
437
7
Summary
444
1
Review Questions
445
1
Problem Solving Cases
445
7
Lesson C
452
41
Working with a Form with Multiple Canvases
452
1
The Clearwater Customer Order Process
452
2
Viewing the Interface Design
454
3
Using a Data Block in a Custom Form
457
1
Creating the Form Button Triggers
458
1
Passing Variable Values Between Forms
459
7
Navigation Between Different Form Canvases
466
2
Creating a Relationship Between a Data Block and a Control Block
468
3
Creating the Relationship Between the Control Block and Data Block
471
1
Creating the Order Line Canvas Order Items Frame Triggers
472
10
Summary
482
1
Review Questions
483
1
Problem Solving Cases
484
9
Using Report Builder
493
110
Lesson A
494
31
Introduction to Report Builder
494
3
Creating a Single-Table Report Using the Report Wizard
497
7
The Report Builder Object Navigator Window
504
1
Creating a Master-Detail Report
505
6
Creating a Report Template
511
9
Summary
520
1
Review Questions
521
1
Problem Solving Cases
522
3
Lesson B
525
40
Report Components
525
1
The Report Data Model
526
3
Layout Frames
529
7
Components of a Master-Detail Report
536
2
Understanding the Report Structure
538
5
Printing Report Records on Separate Pages
543
1
Repositioning the Report Objects
544
8
Adjusting the Spacing Between Report Columns
552
2
Creating a User Parameter
554
3
Summary
557
1
Review Questions
558
1
Problem Solving Cases
559
6
Lesson C
565
38
The Northwoods University Student transcript Report
565
2
Creating a Report Summary Column
567
6
Creating Formula Columns
573
14
Creating and Running an Executable Report File
587
1
Running a Report from a Form
588
1
Modifying the Report Query
589
1
Parameter Lists
590
2
Using the Run_Product Procedure to Run the Report
592
3
Summary
595
1
Review Questions
596
2
Problem Solving Cases
598
5
Using Graphics Builder
603
50
Displaying Data in Charts
604
2
Creating a Chart
606
10
Starting Graphics Builder
606
2
Creating the Chart Query
608
3
Defining the Chart Properties
611
2
Editing and Formatting the Chart Display
613
3
Running the Chart and generating an Executable Chart File
616
11
Creating a Column Chart
618
1
Creating a Chart Manually
619
2
Creating a Layout Manually
621
2
Formatting the Layout
623
4
Creating a Chart Drill-Down Relationship
627
4
Creating a Form That Calls a Graphics Chart
631
5
Modifying the Chart Query
632
2
Modifying the Form
634
2
Creating a Form with an Embedded Graphics Chart
636
6
Creating a Report with an Embedded Graphics Chart
642
6
Summary
648
1
Review Questions
649
1
Problem Solving Cases
650
3
Creating an Integrated Database Application
653
62
Lesson A
654
27
Designing an Integrated Database Application
654
3
Creating a Global Path Variable
657
1
Creating a Splash Screen
658
2
Configuring the Splash Screen Window
660
1
Creating an Image Item in the Splash Window
661
5
Creating the When-Timer-Expired Trigger
666
3
Creating the Iconic Buttons
669
3
Creating the Button Triggers
672
2
Summary
674
1
Review Questions
675
1
Problem Solving Cases
676
5
Lesson B
681
34
Using Project Builder to Organize and Access Project Files
681
1
Creating a New Project
681
4
Viewing Project Dependencies
685
3
Adding Files to a Project
688
1
Creating a Predefined Connection
689
1
Creating New Projects, Reopening Projects, and Deleting Projects
690
1
Opening, Editing, and Compiling Input Files
691
2
Adding Pull-Down Menus to Forms
693
2
Using the Menu Editor
695
2
Closing and Reopening Menu Module Files
697
1
Creating the Access Key Selections
698
1
Modifying the Iconic Button Triggers and Creating the Menu Item Action Triggers
699
5
Compiling and Debugging the Executable Menu File
704
1
Adding the Menu Module to the Project
705
3
Replacing Called Form Pull-Down Menus
708
2
Summary
710
1
Review Questions
711
1
Problem Solving Cases
712
3
Creating Web Applications Using the Oracle Application Server
715
51
Lesson A
716
29
Web Basics
716
1
Web Communications and Protocols
717
1
Web Addresses
718
1
Running Multiple web Server Listeners on the Same Computer
718
1
Static and Dynamic Web Pages
719
1
The Oracle application Server
720
1
Creating Dynamic Web Pages
721
1
Creating a LiveHTML Web Page
722
12
Aligning Text Using HTML Tables
734
6
Summary
740
2
Review Questions
742
1
Problem Solving Cases
742
3
Lesson B
745
21
Using PL/SQL to process Form Inputs
745
1
HTML Form Commands
745
4
Debugging HTML Forms
749
1
Avoiding Displaying Form Parameters in a URL
750
2
Using JavaScript for Client-Side Form Processing
752
2
Using JavaScript to Validate Form Inputs
754
8
Summary
762
1
Review Questions
763
1
Problem Solving Cases
764
2
Index
766