
How to Sort a Block by Clicking Column Headings in Oracle Forms
Turn column headings into sort buttons in Oracle Forms 14.1.2, with a second click that reverses the order and an arrow on the sorted column.
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.

Turn column headings into sort buttons in Oracle Forms 14.1.2, with a second click that reverses the order and an arrow on the sorted column.

Keep a parent record in step with its detail rows in Oracle Forms 14.1.2, in one transaction, and show the change without locking errors.

Bring an open Oracle Forms 14.1.2 form to the front and let it catch up with a record chosen in another form, instead of opening a second copy.

Give an Oracle Forms 14.1.2 application a home screen of the day's figures that refreshes on return and shows each role what it may open.

Let users sign in to an Oracle Forms 14.1.2 application once, with their role shared by every form they open afterwards.

Write one procedure that exports any block to a CSV file in Oracle Forms 14.1.2, with the columns the user sees in the order they are sorted.

Show users how far a long task has come in Oracle Forms 14.1.2 with the new Progress Bar display item, kept moving with SYNCHRONIZE.

Keep rows that other tables refer to in Oracle Forms 14.1.2 by turning Delete Record into an update of an active flag with ON-DELETE.

Repeat last time's detail lines in Oracle Forms 14.1.2 by copying them from the database into a block as new records the user checks and saves.

Let users tick rows and act on all of them at once in Oracle Forms 14.1.2, with a running count, Select All, and a single commit.

Refuse records whose time ranges overlap in Oracle Forms 14.1.2, whether the other record is in the database or in the same save.

Require a field only when another field calls for it in Oracle Forms 14.1.2, one record at a time, and let Forms' own validation enforce it.

Make one list follow another in Oracle Forms 14.1.2 with an LOV that reads the first item, and learn why a second poplist fails in multi-record blocks.

Let users find records by any mix of criteria in Oracle Forms 14.1.2, with a WHERE clause built from bind variables instead of typed values.

Inventory, change, and build Oracle Forms 14.1.2 modules from Java with JDAPI, and add what Forms Builder would have added for you.

Compile a whole Oracle Forms 14.1.2 application in the right order from a script, and keep forms as XML to see every change.

Move Oracle Forms applications from older releases to 14.1.2: what changed, the upgrade steps, the Migration Assistant, and RP2RRO.

Identify users, keep secrets on the server, and close the common holes of an Oracle Forms 14.1.2 installation, with a security checklist.