Stop Hacking Data Integrity: Moving from Trigger Gymnastics to 26ai AssertionsFor a long time, compound triggers have been the unsung heroes of the Oracle world. They weren't always our first choice because of their complexity, but they were the reliable "Swiss Army knives" we Mar 19 · 5 min readbintsiful.hashnode.dev
What a Room Booking Question on Oracle Forums Taught Me About Data Modeling in Oracle APEXI was recently poking around the Oracle developer community—specifically the Oracle SQL&PL/SQL Forums, which is still a goldmine if you can ignore the occasional grumpy old-timer—and found a guy strugMar 17 · 7 min readbintsiful.hashnode.dev
Mastering apex.region().refresh() in Modern APEXFor years, refreshing an APEX region was… messy. You probably did this: JavaScript $("#myRegion").trigger("apexrefresh"); And hoped for the best. Sometimes it worked. Sometimes it jumped to the top. Mar 12 · 4 min readbintsiful.hashnode.dev
Effortless JSON Generation in Oracle APEX — Part 2What Oracle Database 26ai Actually Changes (From an APEX Developer’s Perspective) If Part 1 was about finally stopping the manual JSON pain,this part is about something more subtle: realizing SQL is Mar 11 · 5 min readbintsiful.hashnode.dev
APEX Tip: Page Items to SubmitIntroduction One issue that I run into periodically–especially when working with dynamic actions–is that the value of a page item in session state doesn’t match its value in the browser (what I call tMar 4 · 4 min readbintsiful.hashnode.dev