Category: Oracle

A client posed a reasonable question; could we just click on a button to reset an Interactive Report? Paraphrasing the conversation, the genesis of this request was that in order to reset a report we need to click Actions > …

Add a “Reset” button to your Interactive Reports Read More »

You may be familiar with the handy Substitution String #TIMING# in Oracle Application Express (read more about TIMING and other Substitution Strings).When you add it to the footer (or header) of a region you get to see how long it …

How to Hide & Show a region’s TIMING during development Read More »

Tagged with:

APEX 5.1 introduced native functionality for warning the user when they attempt to navigate away from a page when the page contains unsaved changes. However, this feature doesn’t track items created via the APEX_ITEM API. Which brings me to the …

Warn on Unsaved Changes for APEX_ITEM Read More »

I often need to have a single item on a page (think a search item above a report for example). I would like this item’s label to still align to the right, but be flush with the left side of …

Single Item CSS Grid Alignment Read More »

Have you been thinking about submitting an abstract for Kscope? The submission deadline for Kscope18 is fast approaching! Submissions close on January 5, 2018! Some of you may still be struggling to think of some topics. I’ve asked Dietmar Aust …

Kscope Submission Ideas Read More »

I recently had this requirement for freezing the column and header on a Classic Report, just the way you can with Excel. The report had too many columns and once you scroll horizontally or vertically you would loose track of …

Freeze Column & Headers Plugin Read More »

As you may already know, APEX 5.1 implements native Warn Before Exit functionality. Basically, if the user makes changes on a page and tries to navigate away before they save their changes, they get a warning. Modal Pages also get …

Warn Before Closing APEX Modal Dialogs Read More »

Modal Dialogs in APEX5 use the Modal Page Title attribute as the Title of the dialog. Often, I wish this valuable area of the page could convey more information. So, I thought I could use a Substitution String in the …

Dynamic Modal Dialog Titles in APEX5 Read More »

I have something to confess, but it shouldn’t come as a surprise – I’m not a very good DBA. … but I’m not supposed to be… I’m a developer! Sure, I can discuss configuration options and architecture, but don’t ask …

OTN Appreciation Day : Pre-Built Developer VMs Read More »

“Substitution Strings, Bind Variables, and APEX Links” oh my. Have you ever build an APEX link manually and perhaps it looked something like this: ‘f?p=&APP_ID.:PAGE:&SESSION.::&DEBUG.:’ We should talk. I used to make this mistake and I’ve seen it made too …

Video: 006 – Substitution Strings, Bind Variables, and APEX Links Read More »