INTRO ( Introduction to Oracle9i SQL
and PL/SQL )
• Relational
Databases, SQL & PL/SQL
• Basic SQL Select Statements
• Restricting and Sorting Data
• Single-Row Functions
• Displaying Data From Multiple
Tables
• Aggregating Data Using Group
Functions
• Sub-Queries
• Multiple Column Sub-Queries
• iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Constraints
• Creating Views
• Oracle Data Dictionary
• Creating Other Database Objects
• Controlling User Access
• Declaring Variables
• Writing Executable Statements
• Interacting with Oracle Server
• Writing Control Structures
• Working with Composite Data
Types
• Writing Explicit Cursors
• Advanced Explicit Cursor Concepts
• Handling Exceptions
DPP ( Develop PL/SQL Program
Units )
• Creating
Procedures
• Creating Functions
• Creating Packages
• Package Concepts
• Oracle Supplied Packages
• Database Triggers
• More Trigger Concepts
• Managing Subprograms and Triggers
• Managing Dependencies
• Manipulating Large Objects
FM6i
B ( Developer6i Forms II )
• Creating
a Menu Model
• Managing Menu Models
• Programming Function Keys
• Responding to Mouse Events
• Controlling Windows and Canvasses
Programmatically
• Defining Data Source
• Working with Oracle8i Objects
in Form Builder
• Controlling Data Block Relationships
• Building Multiple Form Applications
• Working with Record Groups
• Using Reusable Components
• Using Server Features in Form
Builder
• Applying Timers
• Including Charts and Reports |
|
RP6i ( Developer6i Reports
)
•
Introduction to Oracle Reports
• Designing and Running Reports
• Report Builder Concepts
• Creating Reports Using Report
Wizard
• Enhancing Reports in the
Live Previewer
• Managing Report Templates
• Report Storage Methods
• Enhancing Reports Using
the Data Model Creating Queries
and Groups
• Enhancing Reports Using
the Data Model Creating Columns
• Enhancing Reports Using
the Layout Model
• Modifying Common Layout
Properties
• Modifying Specific Layout
Properties
• Creating and Using Report
Parameters
• Embedding a chart in a Report
• Enhancing a Matrix Report
• Coding PL/SQL Triggers in
Report
• Building a Web Report
• Using the report builder
built-in package Report Parameters
• Customizing Report at runtime
• Building Reports –
Efficiency Guidelines
FM6i A ( Developer6i
Forms I )
•
Introduction to Oracle Forms Developer
and Oracle Forms Server
• Running a Form Builder Application
• Working in the Form Builder
Environment
• Creating a Basic Form Module
• Working with Data Blocks
and Frames
• Working with Text Items
• Creating LOV’s and
Editors
• Creating Additional Input
Items
• Creating non-input Items
• Creating Windows and Content
Canvases
• Working with other Canvases
• Introduction to Triggers
• Producing Triggers
• Debugging Triggers
• Adding Functionality to
Items
• Runform Messages and Alerts
• Query Triggers
• Validation
• Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code
• Introducing Multiple Forms
Application
|
