Author: Jorge Rimblas

Dynamic Modal Dialog Titles in APEX5

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

Posted in APEX, JavaScript, Modal Dialogs, Oracle

OTN Appreciation Day : Pre-Built Developer VMs

ThanksOTN

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

Posted in Oracle, OTN, Technology

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

006-substitution-strings-bind-variables-and-apex-links

“Substitution Strings, Bind Variables, and APEX Links” oh my. Have you ever build an APEX link manually and perhaps it looked something like this:

We should talk. I used to make this mistake and I’ve seen it made too

Posted in APEX, Oracle, Performance, Video

Video: 005 – Restore screen position after refresh

Save Scroll Position

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.

Posted in APEX, Classic Reports, Interactive Reports, JavaScript, Oracle, Video, Web

Video: Part 4 – Implementing Drag & Drop functionality

dragNdrop

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

Posted in APEX, Classic Reports, Javascript, JavaScript, Oracle, Video, Web

Implementing Drag & Drop in your APEX applications

dragNdrop

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

Posted in APEX, Javascript, Oracle, Web

Video: Part 3 – Adding styling with CSS

Before & After with CSS

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:

Posted in APEX, Classic Reports, CSS, Oracle, Video, Web

Video: Part 2 – APEX Classic Report Named Column Templates

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

Posted in APEX, Classic Reports, Video

Video: Part 1- APEX Classic Report Named Column Templates

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.

Posted in APEX, Classic Reports, KScope, Oracle, Video

UNION or UNION ALL

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

Posted in Oracle