| |
| |
| Preface | |
| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Preparing for OCP DBA Exam 1: SQL and PL/SQL | |
| |
| |
| Selecting Data from Oracle | |
| |
| |
| Selecting Rows | |
| |
| |
| Writing SELECT Statements | |
| |
| |
| Performing Arithmetic Equations | |
| |
| |
| Handling NULL Values | |
| |
| |
| Changing Column Headings with Column Aliases | |
| |
| |
| Putting Columns Together with Concatenation | |
| |
| |
| Editing SQL Queries Within SQL*Plus | |
| |
| |
| Limiting and Refining Selected Output | |
| |
| |
| The ORDER BY Clause | |
| |
| |
| The WHERE Clause | |
| |
| |
| Using Single-Row Functions | |
| |
| |
| Various Single-Row Functions Explained | |
| |
| |
| Using Functions in SELECT Statements | |
| |
| |
| Date Functions | |
| |
| |
| Conversion Functions | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Advanced Data Selection in Oracle | |
| |
| |
| Displaying Data from Multiple Tables | |
| |
| |
| Select Statements That Join Data from More than One Table | |
| |
| |
| Creating Outer Joins | |
| |
| |
| Joining a Table to Itself | |
| |
| |
| Group Functions and Their Uses | |
| |
| |
| Identifying Available Group Functions | |
| |
| |
| Using Group Functions | |
| |
| |
| Using the GROUP BY Clause | |
| |
| |
| Excluding GROUP Data with HAVING | |
| |
| |
| Using Subqueries | |
| |
| |
| Nested Subqueries | |
| |
| |
| Subqueries in Other Situations | |
| |
| |
| Putting Data in Order with Subqueries | |
| |
| |
| Using Runtime Variables | |
| |
| |
| Entering Variables at Run Time | |
| |
| |
| Automatic Definition of Runtime Variables | |
| |
| |
| ACCEPT: Another Way to Define Variables | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Creating the Oracle Database | |
| |
| |
| Overview of Data Modeling and Database Design | |
| |
| |
| Stages of System Development | |
| |
| |
| Basic Types of Data Relationships | |
| |
| |
| Relational Database Components | |
| |
| |
| Reading an Entity-Relationship Diagram | |
| |
| |
| Creating the Tables of an Oracle Database | |
| |
| |
| Creating a Table with Integrity Constraints | |
| |
| |
| Using Table Naming Conventions | |
| |
| |
| Datatypes and Column Definitions | |
| |
| |
| Indexes Created by Constraints | |
| |
| |
| Creating One Table with Data from Another | |
| |
| |
| The Oracle Data Dictionary | |
| |
| |
| Available Dictionary Views | |
| |
| |
| Querying the Data Dictionary | |
| |
| |
| Manipulating Oracle Data | |
| |
| |
| Inserting New Rows into a Table | |
| |
| |
| Making Changes to Existing Row Data | |
| |
| |
| Deleting Data from the Oracle Database | |
| |
| |
| The Importance of Transaction Control | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Creating Other Database Objects in Oracle | |
| |
| |
| Table and Constraint Modifications | |
| |
| |
| Adding and Modifying Columns | |
| |
| |
| Modifying Integrity Constraints | |
| |
| |
| Enabling or Disabling Constraints | |
| |
| |
| Dropping Tables | |
| |
| |
| Truncating Tables | |
| |
| |
| Changing Names of Objects | |
| |
| |
| Viewing Dictionary Comments on Objects | |
| |
| |
| Sequences | |
| |
| |
| Role of Sequences | |
| |
| |
| Creating Sequences | |
| |
| |
| Using Sequences | |
| |
| |
| Modifying a Sequence Definition | |
| |
| |
| Removing Sequences | |
| |
| |
| Views | |
| |
| |
| Data Dictionary Views | |
| |
| |
| Creating Simple and Complex Views | |
| |
| |
| Creating Views that Enforce Constraints | |
| |
| |
| Modifying Views | |
| |
| |
| Removing Views | |
| |
| |
| Indexes | |
| |
| |
| Manual and Automatic Indexes | |
| |
| |
| Uses for Indexes | |
| |
| |
| Index Structure and Operation | |
| |
| |
| Creating Indexes | |
| |
| |
| Removing Indexes | |
| |
| |
| Guidelines for Creating Indexes | |
| |
| |
| User Access Control | |
| |
| |
| Oracle Database Security Model | |
| |
| |
| Granting System Privileges | |
| |
| |
| Using Roles to Manage Database Access | |
| |
| |
| Granting Object Privileges | |
| |
| |
| Changing Passwords | |
| |
| |
| Granting and Revoking Object Privileges | |
| |
| |
| Using Synonyms for Database Transparency | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Introducing PL/SQL | |
| |
| |
| Overview of PL/SQL | |
| |
| |
| Using PL/SQL to Access Oracle | |
| |
| |
| PL/SQL Program Constructs | |
| |
| |
| Developing a PL/SQL Block | |
| |
| |
| Declaring and Using Variables | |
| |
| |
| Variable Value Assignment | |
| |
| |
| Interacting with the Oracle Database | |
| |
| |
| Using SQL Statements in PL/SQL | |
| |
| |
| Using Implicit Cursor Attributes | |
| |
| |
| Transaction Processing in PL/SQL | |
| |
| |
| Controlling PL/SQL Process Flow | |
| |
| |
| Conditional Statements and Process Flow | |
| |
| |
| Using Loops | |
| |
| |
| Explicit Cursor Handling | |
| |
| |
| Implicit vs. Explicit Cursors | |
| |
| |
| Declaring and Using Explicit Cursors | |
| |
| |
| Parameters and Explicit Cursors | |
| |
| |
| Writing CURSOR FOR Loops | |
| |
| |
| Error Handling | |
| |
| |
| Three Basic Types of Exceptions | |
| |
| |
| Identifying Common Exceptions | |
| |
| |
| Coding the Exception Handler | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Preparing for OCP Exam 2: Developing PL/SQL Program Units | |
| |
| |
| Procedures and Functions in PL/SQL Development | |
| |
| |
| Developing Stored Procedures and Functions | |
| |
| |
| Permissions and PL/SQL Programs | |
| |
| |
| Creating PL/SQL Procedures | |
| |
| |
| Parameter Passing | |
| |
| |
| Creating PL/SQL Functions | |
| |
| |
| Using SQL*Plus to Create Procedures and Functions | |
| |
| |
| Entering PL/SQL Code in SQL*Plus | |
| |
| |
| Invoking Procedures and Functions in SQL*Plus | |
| |
| |
| Code Compilation in Oracle Using SQL*Plus | |
| |
| |
| Creating Procedures and Functions with Procedure Builder | |
| |
| |
| Using Procedure Builder Command Line to Develop PL/SQL | |
| |
| |
| Parts of the Procedure Builder GUI | |
| |
| |
| Using Procedure Builder GUI to Develop Client-Side PL/SQL | |
| |
| |
| Using Procedure Builder GUI to Develop Server-Side PL/SQL | |
| |
| |
| Running Pl/SQL Programs in Procedure Builder | |
| |
| |
| Handling Exceptions in PL/SQL | |
| |
| |
| Handling Oracle-Defined Exceptions | |
| |
| |
| Handling User-Defined Exceptions | |
| |
| |
| Using RAISE_APPLICATION_ERROR() | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Debugging PL/SQL Procedures and Functions | |
| |
| |
| Methods of Debugging Server-Side PL/SQL | |
| |
| |
| Introducing the DBMS_OUTPUT Package | |
| |
| |
| A Tour of the DBMS_OUTPUT Package | |
| |
| |
| DBMS_OUTPUT Procedures in Action | |
| |
| |
| Debugging PL/SQL with Procedure Builder | |
| |
| |
| Finding Errors in Code Compilation | |
| |
| |
| Using Breakpoints to Debug Errors in Code Execution | |
| |
| |
| Using Debug Triggers for Debugging Code Execution | |
| |
| |
| Using Oracle-Supplied Packages for Debugging | |
| |
| |
| Overview of Oracle-Supplied Packages in Procedure Builder | |
| |
| |
| Packages for Application Component Communication | |
| |
| |
| Packages for Tuning, Portability, and Compatibility | |
| |
| |
| Packages for Debugging PL/SQL | |
| |
| |
| Case Study of Debugging with Oracle-Supplied Packages | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Managing Procedures, Functions, and Procedural Dependency | |
| |
| |
| Managing Procedures and Functions | |
| |
| |
| Dictionary Views on Stored Procedures | |
| |
| |
| Security for Owner and User on Stored PL/SQL | |
| |
| |
| Managing Procedure Dependencies | |
| |
| |
| Tracking Procedural Dependencies | |
| |
| |
| Database Object Changes and Stored Procedures | |
| |
| |
| Managing Procedural Dependencies in One Database | |
| |
| |
| Managing Procedural Dependencies in Distributed Databases | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Developing and Using Packages | |
| |
| |
| Developing PL/SQL Packages | |
| |
| |
| Overview of Using PL/SQL Packages | |
| |
| |
| Creating Packages to Bundle PL/SQL Constructs | |
| |
| |
| Public and Private Objects in Packages | |
| |
| |
| Compiling and Running Packages | |
| |
| |
| Managing PL/SQL Packages on the Database | |
| |
| |
| Managing Package Specification Dependency | |
| |
| |
| Managing Compilation Dependency and Packages | |
| |
| |
| Managing Procedure Dependency in Packages | |
| |
| |
| Using Pragma RESTRICT_REFERENCES | |
| |
| |
| Managing Packages and Security | |
| |
| |
| Using Oracle Server-Supplied Packages | |
| |
| |
| Overview of Oracle Server-Supplied Packages | |
| |
| |
| Server Packages for Transaction Processing | |
| |
| |
| Server Packages for Advanced Application Development | |
| |
| |
| Server Packages for DBAs and Application Administration | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Developing and Using Database Triggers | |
| |
| |
| Developing Database Triggers | |
| |
| |
| Identifying Different Trigger Types | |
| |
| |
| Creating Statement Triggers | |
| |
| |
| Creating Row Triggers | |
| |
| |
| Dictionary Information about Triggers | |
| |
| |
| Managing Triggers | |
| |
| |
| Managing Trigger Development | |
| |
| |
| Required Security and Trigger Availability | |
| |
| |
| Understanding Trigger Firing Mechanisms | |
| |
| |
| Creating Triggers that Complement the Oracle Database | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Preparing for OCP Exam 3: Building Forms I | |
| |
| |
| Introduction to Oracle Developer/2000 | |
| |
| |
| Overview of the Developer/2000 Package | |
| |
| |
| Features and Benefits of Using Developer/2000 | |
| |
| |
| Component Groups in Developer/2000 | |
| |
| |
| Introduction to Developer/2000 Builder Tools | |
| |
| |
| Builder Tools for Project Management | |
| |
| |
| Builder Tools for Front-End Development | |
| |
| |
| Builder Tools for Back-End Development | |
| |
| |
| Customizing Your Developer/2000 Session | |
| |
| |
| Navigating the Developer/2000 Interface | |
| |
| |
| Customizing Project Builder | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Form Builder | |
| |
| |
| Working in the Form Builder Environment | |
| |
| |
| Identifying the Main Form Builder Executables | |
| |
| |
| Identifying the Main Components of Form Builder | |
| |
| |
| Identifying the Main Objects in a Form Module | |
| |
| |
| Creating Basic Form Modules | |
| |
| |
| Creating a Form Module | |
| |
| |
| Using Data Block Wizard to Create and Modify Data Blocks | |
| |
| |
| Creating and Modifying Layouts Using the Layout Wizard | |
| |
| |
| Saving, Compiling, and Running a Form Module | |
| |
| |
| Form Builder File Formats and Their Characteristics | |
| |
| |
| Creating Data Blocks with Relationships | |
| |
| |
| Running a Master/Detail Form Module | |
| |
| |
| Running a Form Builder Application | |
| |
| |
| Understanding the Runtime Environment | |
| |
| |
| Navigating a Form Builder Application | |
| |
| |
| Understanding the Two Modules of Forms Runtime Operation | |
| |
| |
| Retrieving Data into a Form Builder Application | |
| |
| |
| Inserting, Updating, and Deleting Records | |
| |
| |
| Displaying Database Errors Using the Help Facility | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Forms Design I | |
| |
| |
| Working with Data Blocks and Frames | |
| |
| |
| Property Palette Components | |
| |
| |
| Manipulating Properties | |
| |
| |
| Controlling the Behavior of Data Blocks | |
| |
| |
| Controlling Frame Properties | |
| |
| |
| Creating Blocks That Do Not Correspond to a Database Object | |
| |
| |
| Deleting Data Blocks and Their Components | |
| |
| |
| Working with Text Items | |
| |
| |
| Introduction to Text Items | |
| |
| |
| Modifying a Text Item's Appearance | |
| |
| |
| Controlling the Data In a Text Item | |
| |
| |
| Modifying the Navigational Behavior of a Text Item | |
| |
| |
| Enhancing the Relationship Between the Text Item and a Database | |
| |
| |
| Modifying the Functionality of a Text Item | |
| |
| |
| Including Help Messages in Your Applications | |
| |
| |
| Creating LOVs and Editors | |
| |
| |
| Introduction to LOVs and Editors | |
| |
| |
| Creating LOVs | |
| |
| |
| Creating Editors | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Forms Design II | |
| |
| |
| Creating Additional Input Items | |
| |
| |
| Introduction to Item Types that Allow Input | |
| |
| |
| Creating a Check Box | |
| |
| |
| Creating a List Item | |
| |
| |
| Creating a Radio Group | |
| |
| |
| Creating Noninput Items | |
| |
| |
| Introduction to Item Types that Do Not Allow Input | |
| |
| |
| Creating a Display Item | |
| |
| |
| Creating an Image Item | |
| |
| |
| Creating a Sound Item | |
| |
| |
| Creating a Button | |
| |
| |
| Creating a Calculated Field | |
| |
| |
| Creating Windows and Content Canvases | |
| |
| |
| Introduction to Windows and Content Canvases | |
| |
| |
| Window and Content Canvases Properties | |
| |
| |
| Displaying a Form Module in Multiple Windows | |
| |
| |
| Working with Other Canvases | |
| |
| |
| Introduction to Canvas Types | |
| |
| |
| Creating an Overlay Effect Using Stacked Canvases | |
| |
| |
| Creating a Toolbar | |
| |
| |
| Creating a Tabbed Interface | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Working with Triggers | |
| |
| |
| Introduction to Form Triggers | |
| |
| |
| Definition of a Trigger | |
| |
| |
| Form Trigger Categories | |
| |
| |
| Form Trigger Types and Scope | |
| |
| |
| Form Trigger Properties | |
| |
| |
| How to Produce Triggers | |
| |
| |
| Writing Trigger Code | |
| |
| |
| Understanding the Use of Built-In Subprograms | |
| |
| |
| Introduction to the When-Window-Closed Trigger | |
| |
| |
| Adding Functionality to Form Items | |
| |
| |
| Supplementing the Functionality of Input Items | |
| |
| |
| Supplementing the Functionality of Noninput Items | |
| |
| |
| Using Query Triggers | |
| |
| |
| Data Block Query Process and Triggers | |
| |
| |
| Writing Triggers That Screen Query Conditions | |
| |
| |
| Writing Triggers to Supplement Query Results | |
| |
| |
| Debugging Triggers | |
| |
| |
| Running a Form Module in Debug Mode | |
| |
| |
| Understanding the Components of the Debugger | |
| |
| |
| Debugging PL/SQL Code | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Forms Processing | |
| |
| |
| Forms Runtime Messages and Alerts | |
| |
| |
| Introduction to the Default Messaging | |
| |
| |
| Handling Errors Using Built-In Subprograms | |
| |
| |
| Controlling System Messages | |
| |
| |
| Creating and Controlling Alerts | |
| |
| |
| Data Validation | |
| |
| |
| Effects of the Validation Unit on a Form | |
| |
| |
| Introduction to Form Builder Validation Properties | |
| |
| |
| Controlling Validation Using Triggers | |
| |
| |
| Navigation | |
| |
| |
| Internal vs. External Navigation | |
| |
| |
| Using Navigation Triggers | |
| |
| |
| Introduction to Built-Ins That Cause Navigation | |
| |
| |
| Transaction Processing | |
| |
| |
| Commit Processing, Transaction Processing, and Triggers | |
| |
| |
| Allocating Automatic Sequence Numbers to Records | |
| |
| |
| Implementing Array DML | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Forms Programming | |
| |
| |
| Writing Flexible Code | |
| |
| |
| Flexible Code and System Variables | |
| |
| |
| Built-In Subprograms that Assist Flexible Coding | |
| |
| |
| Writing Code to Reference Objects by Internal ID | |
| |
| |
| Writing Code to Reference Objects Indirectly | |
| |
| |
| Sharing Objects and Code | |
| |
| |
| Inheriting Properties from Property Classes | |
| |
| |
| Grouping Related Objects for Reuse | |
| |
| |
| Reusing Objects from an Object Library | |
| |
| |
| Reusing PL/SQL code | |
| |
| |
| Managing Multiple-Form Applications | |
| |
| |
| Defining Multiple-Form Functionality | |
| |
| |
| Calling One Form from Another | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Preparing for OCP Exam 4: Building Forms II | |
| |
| |
| Project Builder | |
| |
| |
| Managing Projects with Project Builder | |
| |
| |
| Benefits of Using Project Builder | |
| |
| |
| Creating Projects and Subprojects | |
| |
| |
| Adding Files to a Project | |
| |
| |
| Implicit and Explicit Dependencies | |
| |
| |
| Compile Options | |
| |
| |
| Delivering a Project | |
| |
| |
| Customizing a Project Builder Environment | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Working with Menu Modules | |
| |
| |
| Creating Menu Modules | |
| |
| |
| Menu Components | |
| |
| |
| Creating, Saving, and Attaching Menu Modules | |
| |
| |
| Setting Menu Properties Using the Property Palette | |
| |
| |
| Creating Menu Toolbars | |
| |
| |
| Creating Pop-Up Menus | |
| |
| |
| Managing Menu Modules | |
| |
| |
| Controlling the Menu Programmatically | |
| |
| |
| Customizing Menu Modules with Substitution Parameters | |
| |
| |
| Implementing Menu Security | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Advanced Forms Programming I | |
| |
| |
| Programming Function Keys | |
| |
| |
| Redefining Function Keys | |
| |
| |
| Determining When Key Triggers Should Be Used | |
| |
| |
| Responding to Mouse Events | |
| |
| |
| Introduction to Mouse Events | |
| |
| |
| Causing a Form Module to Respond to Mouse Movement | |
| |
| |
| Causing a Form Module to Respond to Mouse Button Actions | |
| |
| |
| Controlling Windows and Canvases Programmatically | |
| |
| |
| Creating Trigger Code to Interact with Windows | |
| |
| |
| Controlling Windows Programmatically | |
| |
| |
| Controlling Canvases | |
| |
| |
| Controlling Data Block Relationships | |
| |
| |
| Definition of Block Coordination | |
| |
| |
| creating and Modifying Relations | |
| |
| |
| Characteristics of Relation-Handling Code | |
| |
| |
| Implementing a Coordination-Type Toggle | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Advanced Forms Programming II | |
| |
| |
| Building Multiple-Form Applications | |
| |
| |
| Different Ways to Invoke Forms | |
| |
| |
| Building Robust Multiple-Form Transactions | |
| |
| |
| Passing Data Between Forms Using Parameter Lists | |
| |
| |
| Defining Data Sources | |
| |
| |
| Introduction to Diverse Data Source Types | |
| |
| |
| Selecting Appropriate Data Sources for Data Blocks | |
| |
| |
| Working with Record Groups | |
| |
| |
| Creating Record Groups at Design Time | |
| |
| |
| Creating and Modifying Record Groups Programmatically | |
| |
| |
| Building Dynamic List Items by Using Record Groups | |
| |
| |
| Using a Global Record Group to Communicate Between Forms | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Advanced Forms Programming III | |
| |
| |
| Including Charts and Reports in Forms | |
| |
| |
| Using the Chart Wizard to Embed Charts in a Form | |
| |
| |
| Using the Report Wizard to Create and Invoke Reports in a Form | |
| |
| |
| Applying Timers to Form Objects | |
| |
| |
| Creating a Timer | |
| |
| |
| Deleting a Timer | |
| |
| |
| Modifying a Timer | |
| |
| |
| Utilizing Reusable Components | |
| |
| |
| Introduction to the Reusable Components | |
| |
| |
| Using the Calendar Class in an Application | |
| |
| |
| Using Server Features in Form Builder | |
| |
| |
| Introduction to Oracle Server Features in Form Builder | |
| |
| |
| Partitioning PL/SQL Program Units | |
| |
| |
| Handling Errors Raised by the Oracle Server | |
| |
| |
| Performing DDL Commands | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Preparing for OCP Exam 5: Building Reports | |
| |
| |
| Introducing Oracle Reports | |
| |
| |
| Designing and Running Reports | |
| |
| |
| Style and Structure of Common Business Reports | |
| |
| |
| Using Runtime Executable to Run Prebuilt Reports | |
| |
| |
| Identifying Various Report Destinations | |
| |
| |
| Viewing Report Output in the Report Previewer | |
| |
| |
| Report Builder Concepts | |
| |
| |
| Executable Components of Oracle Reports | |
| |
| |
| Invoking Report Builder and Its Components | |
| |
| |
| Main Objects in a Report | |
| |
| |
| Creating Reports with Report Wizard | |
| |
| |
| Creating Simple Tabular Reports with Report Wizard | |
| |
| |
| Methods for Building Report Queries | |
| |
| |
| Summarizing Report Values | |
| |
| |
| Modifying Style and Content of Reports | |
| |
| |
| Other Report Styles Available in Report Wizard | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Oracle Reports: Introduction to Report Builder | |
| |
| |
| Modifying Reports using Live Previewer | |
| |
| |
| Describing the Live Previewer | |
| |
| |
| Modifying Display of Report Data with Live Previewer | |
| |
| |
| Modifying Position of Report Data with Live Previewer | |
| |
| |
| Adding Page Numbers and Current Date to Reports | |
| |
| |
| Managing Report Templates | |
| |
| |
| Describing the Template Regions | |
| |
| |
| Modifying Template Default and Override Attributes | |
| |
| |
| Modifying Predefined Report Templates | |
| |
| |
| Registering Custom Templates | |
| |
| |
| Report Storage Methods | |
| |
| |
| Managing Storage of Report Definitions | |
| |
| |
| Report Types and Their Portability | |
| |
| |
| Converting Reports to Different Storage Types | |
| |
| |
| Upgrading Report and Printer Definition Files | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Enhancing Data Content in Report Builder | |
| |
| |
| Using the Data Model to Create Queries and Groups | |
| |
| |
| Data Model Objects and Their Relationships | |
| |
| |
| Creating Groups to Modify Report Hierarchy | |
| |
| |
| Changing Order of Data in Groups | |
| |
| |
| Using Group Filters to Eliminate Data from Reports | |
| |
| |
| Linking Data from Different Queries | |
| |
| |
| Using the Data Model to Create Columns | |
| |
| |
| Identifying Data Model Columns | |
| |
| |
| Using Columns to Display File Contents | |
| |
| |
| Creating and Using Formula Columns | |
| |
| |
| Creating and Using Summary Columns | |
| |
| |
| Creating and Populating Placeholder Columns | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Enhancing Layout and Properties in Report Builder | |
| |
| |
| Enhancing Reports Using the Layout Model | |
| |
| |
| Viewing and Modifying Objects in Four Report Regions | |
| |
| |
| Designing Multipanel Reports | |
| |
| |
| Layout Objects and Their Relationships | |
| |
| |
| Modifying Existing Report Layout with Layout Model Tools | |
| |
| |
| Separating Tabular Data Columns with Lines | |
| |
| |
| Creating Buttons to Display Multimedia Objects | |
| |
| |
| Creating Explicit Anchors to Alter Object Positions | |
| |
| |
| Modifying Layout Properties in Reports | |
| |
| |
| Using Link Files in Reports to DisplayFile Contents | |
| |
| |
| Modifying Layout Properties Common to All Object Types | |
| |
| |
| Modifying Layout Properties Specific to One Object Type | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Developing Other Features in Reports | |
| |
| |
| Using Report Parameters and Parameter Forms | |
| |
| |
| Controlling Report Output with Parameters | |
| |
| |
| Creating User Parameters in a Report | |
| |
| |
| Creating Lists of Values for Parameter Input | |
| |
| |
| Incorporating User Parameters into Queries | |
| |
| |
| Using and Modifying System Parameters | |
| |
| |
| Building Parameter Form Layouts for Data Entry | |
| |
| |
| Customizing Parameter Form Layouts | |
| |
| |
| Embedding Charts in Reports | |
| |
| |
| Creating Graphics Charts with Chart Wizard | |
| |
| |
| Displaying Existing Graphics Charts in Reports | |
| |
| |
| Using Parameters for Dynamic Modification of Chart Data | |
| |
| |
| Developing and Enhancing Matrix Reports | |
| |
| |
| Designing a Matrix Data Model | |
| |
| |
| Designing a Matrix Layout Model | |
| |
| |
| Displaying Zeros in Cells with No Value | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Advanced Topics in Report Design | |
| |
| |
| Coding PL/SQL Triggers in Reports | |
| |
| |
| Different Types of Triggers and Their Usage | |
| |
| |
| Writing and Referencing Common Code | |
| |
| |
| Creating and Referencing a PL/SQL Library | |
| |
| |
| Using Report Builder Built-in Packages | |
| |
| |
| Report Builder SRW Built-In Package Contents | |
| |
| |
| Using SRW Package Procedures and Functions | |
| |
| |
| Output Messages at Run Time | |
| |
| |
| Using Temporary Tables in Reports | |
| |
| |
| Modifying Visual Attributes at Run Time | |
| |
| |
| Maximizing Performance Using Reports Server | |
| |
| |
| Comparing Local Client and Report Server Reporting | |
| |
| |
| The Reports Server Architecture | |
| |
| |
| Viewing and Scheduling Reports in Queue Manager | |
| |
| |
| Invoking Oracle Reporting ActiveX Control from Other Apps | |
| |
| |
| Building Reports for Different Environments | |
| |
| |
| Character Mode vs. Bitmap Mode | |
| |
| |
| Considerations When Building Reports for Different GUIs | |
| |
| |
| Character Mode Reports and Their Settings | |
| |
| |
| Facilities for Building Reports in Other Languages | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Appendix: Preparing for Developer 2.0 New Features Upgrade Exam | |
| |
| |
| Managing Projects with Project Builder | |
| |
| |
| Creating Form Documents Using Wizards | |
| |
| |
| Representing Data Within Your Application | |
| |
| |
| Enhancing Items | |
| |
| |
| Enhancing Interactivity | |
| |
| |
| Ensuring Consistency Across Applications | |
| |
| |
| Including Charts and Reports | |
| |
| |
| Creating Reports Using Report Wizard | |
| |
| |
| Modifying and Enhancing Reports | |
| |
| |
| Maximizing Performance Using Reports Server | |
| |
| |
| Deploying Reports on the Web | |
| |
| |
| Index | |