Online training on Oracle PL SQL D2K Forms Reports

Course Content: Oracle Pl SQL:

Chapter 1

1. Database Models

2. Beginnings

3. Some Introductory Terminology

4. Normalization

5. First Normal Form

6. Higher Order Normal Forms

Chapter 2

7. SQL

8. SQL*Plus

9. Oracle Architecture

10. Interfaces to Oracle

11. Command Line Interface

12. Viewing a Sample Table

13. The Graphical User Interface

14. The SQL Buffer

15. The Web-Based Interface

16. Describe

Chapter 3

17. The Entity Relationship Model

18. Entity Relationship Diagrams

19. The Sample Database

20. ER Diagram for Sample Database

21. Creating the Sample Data

22. Viewing Sample Data

23. Data Types of the Sample Data

Chapter 4

24. The Entity Relationship Model

25. Entity Relationship Diagrams

26. The Sample Database

27. ER Diagram for Sample Database

28. Creating the Sample Data

29. Viewing Sample Data

30. Data Types of the Sample Data

Chapter 5

1. DML Statements

2. The SELECT Statement

3. The INSERT Statement

4. The DELETE Statement

5. The UPDATE Statement

6. More SQL*Plus Commands

Chapter 6

1. Transactions

2. Command Classification

3. Savepoints

4. The SET TRANSACTION Command

Chapter 7

1. Simple Selects

2. Comparison Operators

3. IN and NOT IN Operators

4. BETWEEN Operator

5. The LIKE Operator

6. Logical Operators

7. IS NULL and IS NOT NULL

8. ANY

9. ALL

Chapter 8

1. Introduction

2. The DISTINCT Keyword

3. Aliases

4. Miscellaneous Functions

5. Mathematical Functions

6. String Functions

7. Date Functions

8. Conversion Functions

9. Pseudo Columns

Chapter 9

1. Joins

2. Cartesian Product

3. Inner Joins

4. Equi-Join

5. Table Aliases

6. Non-Equi Join

7. Non-Key Join

8. Reflexive Join

9. Natural Join

10. Outer Joins

11. Right Outer Join

12. Left Outer Join

13. Full Outer Join

14. Oracle-Specific Syntax for Outer Joins

Chapter 10

1. Introduction

2. Selection Criteria

3. Union

4. Union All

5. Intersect

6. Minus

Chapter 11

1. Introduction

2. Using a Sub query with a DML Statement

3. Typical Sub queries

4. Sub query Operators

5. Standard vs. Correlated Sub queries

6. Correlated Sub query Example

7. Predicate Operators

Chapter 12

1. SQL Statements

2. GROUP BY Clause

3. HAVING Clause

4. Order of a SELECT Statement

Chapter 13

1. More Database Objects

2. Relational Views

3. Updating a View

4. Create or Replace

5. Forcing a View

6. The Data Dictionary Revisited

7. Indexes

8. Synonyms

Chapter 14

1. The SET Command

2. The COLUMN Command

3. The BREAK Command

4. The COMPUTE Command

Chapter 15

1. SQL vs. PL/SQL

2. A Few Simple Examples

3. Saving Procedures

4. A More Complete Picture

5. Comments

6. Variable Substitution

7. Simple Exception Handling

8. Advantages of PL/SQL

9. Assignments

Chapter 16

1. Declarations

2. Standard Data Types

3. Initialization

4. Variable Names

5. Specialized Data Types - %TYPE

6. Specialized Data Types - %ROWTYPE

7. Building Your Own Data Types - Records

8. A Quick look at Loops

9. Arrays

10. Tables

11. Nested Blocks

Chapter 17

1. Introduction

2. Assignments

3. Decision Making Statements

4. Simple Loops

5. Loops - for

6. Loops - indefinite

7. Loops - while

8. Simple Loops

9. Nested Loops

10. Boolean Variables

11. PL/SQL Relational Operators

12. PL/SQL Logical Operators

13. The CASE Construct

Chapter 18

1. Introduction

2. Cursor Manipulation

3. Using the Cursor

4. For Loops Cursors

5. Cursor Attributes

6. Cursor Parameters

7. Nested Cursors

8. Cursor Exceptions

Chapter 19

1. Errors in Programs

2. Run Time Exceptions

3. Oracle Built In Exceptions

4. Unnamed Exceptions

5. Built in Exception Functions

6. Creating Your Own Exceptions

7. Building Non Terminating Exceptions

Chapter 20

1. Introduction

2. Creating a Procedure

3. Example Procedure

4. Using Parameters

5. Functions

6. Procedures and Exceptions

Oracle Forms:

Introduction

• Notes on Course Content
• Preparation

Mouse and Key Triggers

• Mouse Triggers
• Cursor Styles
• Key Triggers

Timers

• Use of Timers
• Creating and Handling Timers
• Timer Triggers and Built-ins

Record Groups

• LOVs and Record Groups
• Record Group Types
• Creating Run-time Record Groups
• Built-in Procedures and Functions
• Record Groups and Lists

Data Block Relationships

• Relation Object Properties
• Creating Relationships Manually
• Procedures and Triggers for Coordination
• Modifying Default Functionality

Multi-Form Applications

• Calling Other Forms
• The OPEN_FORM Procedure
• The CALL_FORM Procedure
• The NEW_FORM Procedure
• Related Built-ins
• Passing Data between Forms
• Creating Parameters and Parameter Lists

Creating Custom Menus

• Menu Modules, Sub Menus and Menu Items
• The Menu Editor
• Menu and Menu Item Properties
• PL/SQL in Menu Modules
• Menu Item Built-ins
• Menu Security
• Menu Parameters
• Popup Menus

Handling Database Objects

• Object Support and Object Types
• Object Tables
• Column Objects
• Handling REF Columns

Using Other Data Sources

• Data Source Types
• Using a FROM Clause Query
• Using Procedures which return REF Cursors
• Using Procedures which return PL/SQL Tables
• Implementing DML using Packaged Procedures

Using Oracle Database Features

• Database Functionality
• Handling PL/SQL Code
• Handling Database Server Errors
• Using the FORMS_DDL Package
• DDL Functionality

Reusable Components

• Reusable Component Definition
• Oracle-Supplied Components
• Using Oracle's Calendar Class Component
• Notes on Active X Controls
• JavaBeans and PJCs

Oracle Reports:

Introduction to Oracle Reports Developer

• Business Intelligence
• Enterprise Reporting
• Oracle Reports Developer
• Oracle Database 10g
• Oracle Developer Suite 10g
• Oracle Application Server 10g
• Oracle AS Reports Services
• oracle AS Reports Services Architecture for the Web

Designing and Running Reports

• Understanding User Requirements
• Designing Reports
• Tabular
• Master-Detail
• Master with Two Details
• Matrix
• Retrieving and Sharing Data
• Running a Report

Exploring Oracle Reports Developer

• Reports Developer Executable
• Invoking Reports Builder
• Reports Builder Modules
• Report Data and Layout
• Reports Builder Components
• Object Navigator
• Report-Level Objects
• Data Model Objects

Creating a Paper Report

• Report Module Components
• Building a Paper Report
• Viewing the Paper Report Output
• Saving the Report Definition
• Reentering the Wizard
• Creating Break Reports
• Break Report Labels
• Creating Mailing Labels and Letters

Enhancing a Basic Paper Report

• What Is the Paper Design?
• The Paper Design Window
• Modifying a Report
• Aligning Columns
• Setting a Format Mask
• Manipulating Objects
• Modifying Visual Attributes
• Applying Conditional Formatting

Managing Report Templates

• Using Report Templates
• Modifying a Template
• Customizing the Template Margin
• Customizing the Template Body
• Adding Web Links to a Template for Report HTML Output
• Predefining Your Own Templates
• Adding a Template Preview Image

Enhancing Reports Using the Data Model: Creating Columns

• Data Model Columns
• Maintaining Data Source Columns
• Producing File Content Output
• Creating a Column
• Creating Summary Columns
• Displaying Subtotals
• Displaying Percentages
• Creating a Formula Column

Controlling the Paper Layout: Common Properties

• Modifying Paper Layout Object Properties
• Common Layout Properties
• Sizing Objects
• Anchors
• Layout Object Relationships
• Pagination Icons in the Paper Layout
• Controlling Print Frequency
• Using Format Triggers

Creating and Using Report Parameters

• Creating User Parameters
• Referencing Parameters in a Report Query
• Using Bind References
• Using Lexical References
• Hints and Tips When Referencing Parameters
• Creating a List of Values
• Referencing System Parameters
• Building a Paper Parameter Form

Coding PL/SQL Triggers

• Types of Triggers in Reports
• Trigger Code
• Using Report Triggers
• Using Data Model Triggers: PL/SQL Group Filter
• Using Data Model Triggers: Parameter Validation
• Using Layout Triggers
• Using Format Triggers
• Event-Based Reporting

Extending Functionality Using the SRW Package

• Contents of the SRW Package
• Outputting Messages
• Executing a Nested Report
• Restricting Data
• Initializing Fields
• Creating a Table of Contents
• Performing DDL Statements
• Setting Format Attributes