Row-Level Security in Oracle APEX with VPD: Show Each User Only Their Own Data
A step-by-step guide to showing each Oracle APEX user only their own rows with Virtual Private Database, one policy function, and no WHERE clauses in the pages.
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 Build Electronic Signatures in Oracle APEX: A Free DocuSign Alternative with a Digital Seal
A step-by-step guide to signing PDFs in your own Oracle APEX schema, with one-time codes, an immutable audit trail, a digital seal, and any PDF tool.
How to Deploy an Oracle Forms Application
Take a multi-form Oracle Forms 14.1.2 application from Forms Builder to users, with the compile order, files, environment, and URL it needs.
How to Structure a Multi-Form Oracle Forms Application
Organize an Oracle Forms 14.1.2 application into a library, template, menu, and forms that share the signed-in user and open each other one way.
How to Show a Record Count Before Scrolling in Oracle Forms
Count the records of a query before it runs in Oracle Forms 14.1.2 and show users where they are, without waiting for the last row to be fetched.
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.
How to Update a Parent Record from POST-INSERT in Oracle Forms
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.
How to Refresh an Open Form with WHEN-FORM-NAVIGATE
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.
How to Build a Dashboard Form in Oracle Forms
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.
How to Build a Sign-In Form in Oracle Forms
Let users sign in to an Oracle Forms 14.1.2 application once, with their role shared by every form they open afterwards.
How to Export Any Block to CSV in Oracle Forms
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.
How to Show a Progress Bar in Oracle Forms
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.
How to Implement a Soft Delete in Oracle Forms
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.
How to Copy Records from the Database into a Block in Oracle Forms
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.
How to Process Selected Rows with Check Boxes in Oracle Forms
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.
How to Prevent Overlapping Records Before Saving in Oracle Forms
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.
How to Make an Item Required Only in Some Records in Oracle Forms
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.
How to Create Dependent Lists in Oracle Forms
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.