Oracle Forms and Oracle APEX are both Oracle technologies for building database-driven applications, but they come from very different generations of application development. Oracle Forms has been used…
Read MoreA complete reference to Oracle Forms triggers — validation triggers, navigation triggers, query triggers, transaction triggers, and key triggers — with real PL/SQL code examples and a quick reference table for all major trigger types.
Read MoreRecord Groups power LOVs, dynamic dropdowns, and in-memory data processing in Oracle Forms. This guide covers all three types, key PL/SQL built-ins like POPULATE_GROUP and POPULATE_LIST, dynamic queries, and common pitfalls to avoid.
Read MoreLearn how to create a multi-row block in Oracle Forms — from using the Data Block Wizard to configuring tabular layouts, scrollbars, visual attributes, and master-detail relationships. A complete practical guide.
Read More
Everything you need to know about Oracle Forms LOVs — how to create them with the wizard, link them to form items, write dynamic queries with bind variables, use KEY-LISTVAL triggers, and troubleshoot common problems.
Read More
Wondering whether to upgrade from Oracle Forms 6i to 12c — or skip directly to APEX? This honest comparison covers the real technical differences, compatibility issues, and what each version means for your team.
Read More
Oracle Forms is a powerful tool for developing database-driven applications. However, like any software development environment, it is prone to errors. Handling errors effectively is crucial for creating…
Read More
Oracle Forms 6i relies heavily on PL/SQL logic blocks to handle events, validations, and business logic efficiently. Below are some of the most useful and commonly used PL/SQL…
Read More
System variables in Oracle Forms 6i are built-in variables that store values related to the form’s runtime environment. These variables help developers manage the behavior of forms, control…
Read More