Oracle Forms and Reports

Module 1 : Introducing Oracle Forms Developer and Forms Services

• Grid Computing
• Oracle 10g Products
• Oracle Application Server 10g Architecture
• Benefits and Components of Oracle Developer Suite 10g
• Running a Forms Developer Application
• Working in the Forms Developer Environment

Module 2 : Creating Forms Modules

• Creating a Basic Forms Module
• Creating a Master-Detail Forms Module
• Modifying the Data Block
• Modifying the Layout

Module 3 : Working with Data Blocks and Frames

• Using the Property Palette
• Managing Object Properties
• Creating and Using Visual Attributes
• Controlling the Behavior and Appearance of Data Blocks
• Controlling Frame Properties
• Creating Control Blocks
• Deleting Data Blocks

Module 4 : Working with Input Items

• Creating Text Items
• Controlling the Behavior and Appearance of Text Items
• Creating LOVs
• Defining Editors
• Creating Check Boxes
• Creating List Items
• Creating Radio Groups

Module 5 : Working with Non Input Items

• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating a Bean Area Item

Module 6 : Working with Windows and Canvases

• Overview of Windows and Canvases
• Displaying a Forms Module in Multiple Windows
• Creating a New Window
• Displaying a Forms Module on Multiple Layouts
• Creating a New Content Canvas
• Creating a New Stacked Canvas
• Creating a New Toolbar Canvas
• Creating a New Tab Canvas

Module 7 : Producing Triggers

• Grouping Triggers into Categories
• Defining Trigger Components: Type, Code, and Scope
• Specifying Execution Hierarchy
• Using the PL/SQL Editor
• Writing Trigger Code
• Using Variables and Built-ins
• Using the When-Button-Pressed and When-Window-Closed Triggers

Module 8 : Debugging Triggers

• The Debugging Process
• The Debug Console
• Setting Breakpoints
• Debugging Tips
• Running a Form in Debug Mode
• Stepping through Code

Module 9 : Adding Functionality to Items

• Coding Item Interaction Triggers
• Defining Functionality for Check Boxes
• Changing List Items at Run Time
• Displaying LOVs from Buttons
• Populating Image Items
• Populating and Displaying Hierarchical Trees
• Interacting with JavaBeans

Module 10 : Run-Time Messages and Alerts

• Built-ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Using Triggers to Intercept System Messages
• Creating and Controlling Alerts
• Handling Server Errors

Module 11 : Query Triggers

• SELECT Statements Issued During Query Processing
• WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time

Module 12 : Validation

• Validation Process
• Controlling Validation Using Properties
• Controlling Validation Using Triggers
• Performing Client-Side Validation with PJCs
• Tracking Validation Status
• Using Built-ins to Control When Validation Occurs

Module 13 : Navigation

• Navigation Overview
• Understanding Internal Navigation
• Using Object Properties to Control Navigation
• Writing Navigation Triggers: When-New–Instance, Pre- and Post- Triggers
• The Navigation Trap
• Using Navigation Built-ins in Triggers

Module 14 : Transaction Processing

• The Commit Sequence of Events
• Characteristics and Common Uses of Commit Triggers
• Testing the Results of Trigger DML
• DML Statements Issued During Commit Processing
• Overriding Default Transaction Processing
• Running Against Data Sources Other Than Oracle
• Getting and Setting the Commit Status
• Implementing Array DML

Module 15 : Writing Flexible Code

• What Is Flexible Code?
• Using System Variables for Flexible Coding
• Using Built-in Subprograms for Flexible Coding
• Referencing Objects by Internal ID
• Referencing Items Indirectly

Module 16 : Sharing Objects and Code

• Working with Object Libraries
• Working with Smart Classes
• Reusing PL/SQL
• Working with PL/SQL Libraries

Module 17 : Introducing Multiple Form Applications

• Multiple Form Applications Overview
• Starting Another Forms Module
• Defining Multiple Form Functionality
• Sharing Data Among Modules

Module 18 : Basic Concepts

• Oracle Reports Builder
• Reports
• Report Styles
• Wizards
• The Object Navigator
• The Report Editor
• Data Model Objects
• Layout Objects
• Parameter Form Objects
• The Property Instructor
• Runtime Views
• Oracle Reports Components

Module 19 : Advanced Concepts

• Reports
• Web Reports
• Data Model Objects
• Layout Objects
• Parameter Form Objects
• PL/SQL
• Templates
• Output Formats and Capabilities
• Data Sources
• Debugging Tools

Module 20 : Visual Index

• Building Basic Reports
• Building Group Reports
• Building Reports w/ Special Formatting
• Building Matrix Reports
• Building Reports for Business Cases
• Building Reports w/ PL/SQL and Java
• Building Reports w/ Pluggable Data Sources

Meet Ananth Tirumanur. Hi there 👋

I work on projects in data science, big data, data engineering, data modeling, software engineering, and system design.

• 👨‍💻 All of my projects are available at https://github.com/akrish1982
• 💬 Ask me about Data engineering, SQL, Databases, Data pipelines, Data infrastructure
• 📄 My work history: https://www.linkedin.com/in/ananthtirumanur/
• ⚡ Fun fact: Marathoner & Casual Birding enthusiast

Connect with me:

• Twitter: @akrish82
• LinkedIn: https://linkedin.com/in/ananthtirumanur/

My Resources:

• LinkedIn Newsletter: Data Engineering with AWS
• Udemy Course: AWS Certified Data Engineer Associate Practice Test
• Python Crash Course: Python Crash Course on Gumroad

Languages and Tools:

AWS, Bash, Docker, Elasticsearch, Git, Grafana, Hadoop, Hive, EMR, Glue, Athena, Lambda, Step Functions, Airflow/MWAA, DynamoDB, Kafka, Kubernetes, Linux, MariaDB, MySQL, Pandas, PostgreSQL, Python, Redis, Scala, SQLite