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
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

Post has attachment
APEX attributes for Escaping Special Characters
A relatively common on the forums is regarding the escaping of special characters in reports, but it seems the developer isn't always sure what is actually happening and how to how to search for it. It seems I've had this on my "to blog" list since April 20...

Post has attachment
Wait while more posts are being loaded