Profile cover photo
Profile photo
Scott Wesley
173 followers -
Oracle Technologist, husband, father, lover of life - not necessarily in that order ;-)
Oracle Technologist, husband, father, lover of life - not necessarily in that order ;-)

173 followers
About
Scott's interests
View all
Scott's posts

Post has attachment
Font APEX between versions
Sometimes, it's the little things in an application that make users happy. Sometimes, it's just the icon on a darn button, card, or menu that makes all the difference. Surely by now you've encountered using icons within Oracle APEX, and we've come a long wa...

Post has attachment
Understanding the User's Perspective
Recently I encountered what I thought was an interesting allegory in regard to software development and understanding the user experience. My three year old approached me with her bottle of milk and requested more, insisting it was empty. Exhibit A - One no...

Post has attachment
2016 Blog Review
It's February, so it must be time to do this. I explore what thoughts arise from looking back, and forward to the future. It helps me to remember stuff, decide what to do, and apparently some people find it interesting. Tools So many tools. And I arguably d...

Post has attachment
How did you get into programming in the first place?
If you want a sanity check on programming life, I recommend you follow @ThePracticalDev in some form. Recently a question was posed regarding we all got into programming in the first place. https://dev.to/ben/how-did-you-get-into-programming-in-the-first-pl...

Post has attachment
APEX Survey Results: Addressing Performance
Yep, I'm still doing this. A bunch of questions to come, many worth the visit. Just a few weeks between drinks, so to speak. My annual review is a little late, too. Anyway... Time for the performance questions in my 2015 survey . A favourite topic of mine, ...

Post has attachment
APEX Survey Results: Addressing Performance
Yep, I'm still doing this. A bunch of questions to come, many worth the visit. Just a few weeks between drinks, so to speak. My annual review is a little late, too. Anyway... Time for the performance questions in my 2015 survey . A favourite topic of mine, ...

Post has attachment
Truncating LISTAGG prior to 12.2
I've been following the LISTAGG problem for a while because I find the function useful. The problem being this error: ORA-01489: result of string concatenation is too long It relates to when the result set is over 4000 characters, eg: with data as (select r...

Post has attachment
Escape Special Characters APEX Demo
A few weeks ago I wrote more detail than expected regarding escaping of special characters. I thought I'd add a simple demonstration, for reference. Consider the following query, with variations of escaped column output. with data as
(select q'[G'day,]'|...

Post has attachment
Re-evaluating APEX Authorization Schemes
Authorization schemes in Oracle APEX are used to control access to page, buttons, and all sorts of other components. In my experience, these are best defined at a privilege level, where the same privilege could be allocated to multiple business roles, but t...

Post has attachment
Wait while more posts are being loaded