PGPhil Grinhaminphilgrinham.hashnode.dev·2d ago · 7 min readBubble Sorting Delimited Strings #JoelKallmanDayIn honor Joel and all he did for the Oracle community, this is a quick blog post on a solution to the problem of sorting a delimited string. The basic premise is a common headache where we are require00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Aug 3 · 4 min readViewing PDF Files in Oracle APEX: Creating a Seamless Document Experience for Business UsersIntroduction As Oracle APEX developers, we often build applications that manage business-critical information—employee records, invoices, purchase orders, customer requests, audit reports, and much mo00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Jul 30 · 6 min readFrom Standard Report to Excel-Like Experience: Enhancing Oracle APEX Interactive Report with Frozen Columns👋 Introduction Have you ever opened an Oracle APEX Interactive Report and found yourself scrolling endlessly across dozens of columns, only to lose sight of the key information you were comparing? If10
PGPhil Grinhaminphilgrinham.hashnode.dev·Jun 30 · 9 min readMaterialized Views: The Sweet SpotThe Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·May 29 · 6 min readOracle finally did it: BOOLEAN is now supported directly in SQL. For years, one of the most curious limitations in Oracle Database was the absence of a real BOOLEAN data type in SQL. Yes — Oracle supported BOOLEAN in PL/SQL for decades. But not in SQL itself. That 00
NANaif Amoodiinnaifamoodi.hashnode.dev·Apr 23 · 2 min readWorking Around an Old Oracle DatabaseWe still work with a client whose day-to-day operation depends heavily on an old Oracle database, so a lot of our integration work ends up being shaped by the quirks of that database. One thing I lear20
BIBenjamin Intsifulinbintsiful.hashnode.dev·Mar 19 · 5 min readStop 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 00
BIBenjamin Intsifulinbintsiful.hashnode.dev·Mar 17 · 7 min readWhat 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 strug00
BIBenjamin Intsifulinbintsiful.hashnode.dev·Feb 28 · 5 min readWhy COUNT(*) Is a Performance TrapJust like most teams that practice Agile methodologies some years ago; It was 4:15 PM. The sprint demo was live. The dashboard looked great until someone clicked the "Customer Health" tab. Then? Silen00
VJVinny Jiménezininsightsapex.vinnyum.tech·Feb 19 · 7 min readCaching Strategies: APEX & Database CacheThe Fastest Query is the One You Never Run 🇪🇸 Leer en Español There is a common misconception in database development: "If it's slow, just add an index." While indexing is critical, it solves a stor00