How to Use Text Items in Oracle Forms
Text items and display items in Oracle Forms 14.1.2: the properties for data, format masks, initial values, input, queries, and help.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Create a Master-Detail Form in Oracle Forms
Join a master and detail block with a relation in Oracle Forms 14.1.2, and control how the details are queried, inserted, deleted, and numbered.
How to Change Block Properties at Run Time Using SET_BLOCK_PROPERTY
Change WHERE and ORDER BY clauses, read LAST_QUERY, and move between blocks at run time with SET_BLOCK_PROPERTY and GO_BLOCK in Oracle Forms.
How to Populate Primary Keys from a Sequence in Oracle Forms
Three ways to fill a primary key from a sequence in Oracle Forms 14.1.2, and why a PRE-INSERT trigger is usually the best one.
How to Create Data Blocks in Oracle Forms
Data blocks and control blocks in Oracle Forms 14.1.2: how to create them, what their navigation, records, and database properties do, and the SQL.
How to Change Form Properties at Run Time Using SET_FORM_PROPERTY
What each property of the Oracle Forms form module does, and how to read and change them at run time with GET_FORM_PROPERTY and SET_FORM_PROPERTY.
How to Compile Oracle Forms Modules Using the Form Compiler
Compile forms, menus, and libraries in Oracle Forms 14.1.2, from Forms Builder shortcuts to frmcmp_batch parameters, errors, and exit codes.
How to Create Modules in Oracle Forms
A guide to the four kinds of Oracle Forms modules, their design and runnable files, and how to convert them to text, XML, or a property listing.
How to Install the CareWell Clinic Sample Schema for Oracle Forms
The sample clinic schema behind every Oracle Forms 14.1.2 example: its tables, sequences, and data, and how to install it and connect.
How to Create Your First Form in Oracle Forms Using the Data Block Wizard
Build a complete data-entry form in Oracle Forms 14.1.2 in minutes with the Data Block Wizard and Layout Wizard, no PL/SQL required.
How to Use Forms Builder in Oracle Forms 14.1.2
A practical tour of Oracle Forms Builder 14.1.2: the Object Navigator, Property Palette, Layout Editor, PL/SQL Editor, menus, and run settings.
How to Install Oracle Forms 14.1.2
A step-by-step guide to installing Oracle Forms 14.1.2 for development, from the JDK and WebLogic domain to the Forms Standalone Launcher.
How to Manage an APEX Instance and Generate Test Data from PL/SQL
A tested guide to APEX_INSTANCE_ADMIN, APEX_APPLICATION_ADMIN, APEX_UI_DEFAULT_UPDATE, APEX_DB_DICTIONARY, and APEX_DG_DATA_GEN in APEX 26.1.
How to Export and Install APEX Applications Using APEX_EXPORT and APEX_APPLICATION_INSTALL
A tested guide to APEX_EXPORT, APEX_APPLICATION_INSTALL, and APEX_APP_OBJECT_DEPENDENCY in Oracle APEX 26.1, for scripts and CI pipelines.
How to Build APEX Plug-ins in PL/SQL Using APEX_PLUGIN and APEX_PLUGIN_UTIL
A tested guide to APEX_PLUGIN and APEX_PLUGIN_UTIL in Oracle APEX 26.1, from render callbacks and Ajax to data, substitutions, and REST sources.
How to Call Generative AI and Search from PL/SQL Using APEX_AI and APEX_SEARCH
A tested guide to APEX_AI, APEX_SEARCH, APEX_SPATIAL, and APEX_PWA in Oracle APEX 26.1, from prompts and chats to search, maps, and push.
How to Create Tasks and Run Workflows from PL/SQL Using APEX_HUMAN_TASK and APEX_WORKFLOW
A tested guide to APEX_HUMAN_TASK, APEX_WORKFLOW, APEX_AUTOMATION, and APEX_BACKGROUND_PROCESS, from approval tasks to workflows and schedules.
How to Filter and Reset Interactive Reports and Grids from PL/SQL Using APEX_IR and APEX_IG
A tested guide to APEX_IR and APEX_IG in Oracle APEX, from adding filters in page processes to resetting, cloning, and reassigning saved reports.