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 …
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 …
“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 »
Picture a Report and Form pages used to edit records. The Report is an Interactive Report and the edit page is Modal. When the modal closes the IR refreshes, but also, the page jumps to the top after the refresh. …
Video: 005 – Restore screen position after refresh Read more »
Do you want to add Drag & Drop functionality to your APEX applications? That’s what this video is all about. You’ll see me working on the list created in the previous episodes (Part 1, Part 2 and Part 3) and …
Video: Part 4 – Implementing Drag & Drop functionality Read more »
I first learned how to implement Drag & Drop functionality from Doug Gault’s presentation at Kaleidoscope 2010 (yes before it was Kscope) “Replicating NetFlix Queue Drag-and-Drop Functionality with Oracle Application Express/jQuery” (Membership required). I mean, I wasn’t actually there, but …
Implementing Drag & Drop in your APEX applications Read more »
This video is all about CSS styling. You’ll see me working on the list created in the previous episodes (Part 1 and Part 2) and transform it to something a lot more interesting. In this 42 minute video you’ll find: …
I’m happy to bring you installment Number 2 of this video series. If you missed the first one, you can find it here Part 1. We’ll call this the “Dynamic Action” edition because that’s what most of the video deals …
Video: Part 2 – APEX Classic Report Named Column Templates Read more »
As part of my Kscope16 presentation “Hooked on Classic (Reports) Learn tips & techniques to make them sing” (live slides here). I demoed a Classic Report with a custom template (a Named Column template), made to look like a list. …
Video: Part 1- APEX Classic Report Named Column Templates Read more »
You may be familiar with the UNION operator in Oracle SQL, but are aware of the UNION ALL operator? Perhaps you will be surprised to hear that more often than not when you write UNION, what you meant to use …