Profile

Cover photo
Scott Wesley
Works at Sage Computing Services
Lives in Perth, Western Australia
171 followers|1,729,107 views
AboutPostsPhotosYouTube

Stream

Scott Wesley

Shared publicly  - 
 
Show report tooltip as notification
Last week I described a method to make the tooltip on information more accessible to the end user. Here is how you could make the same information available to touchscreen users. 1) First step, as before , is to define the HTML Expression of the column to i...
Last week I described a method to make the tooltip on information more accessible to the end user. Here is how you could make the same inf...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Extend column tooltip to table cell
Quite sometime ago while still on 3.x I described a simple way to add tooltips in a report using standard HTML in a HTML Expression. <span title="#RECENT_NOTE#">#MY_COLUMN#</span> However, it will only appear when hovering over the span content, not anywher...
Quite sometime ago while still on 3.x I described a simple way to add tooltips in a report using standard HTML in a HTML Expression. <span...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Users still double click buttons
Despite web pages having been around for quite some time, and users have been given years of affordance , people still double click on links & buttons in web pages. This can cause a few issues in an APEX environment as the underlying process may get execute...
Despite web pages having been around for quite some time, and users have been given years of affordance, people still double click on links & buttons in web pages. This can cause a few issues in an APEX environment as the underlying process may get executed twice, and today I came up with what I ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: Instrumentation Thoughts
This question in my  2015 survey  may is a followup from question 7 regarding instrumentation Q8: Do you have any thoughts you'd like to share on instrumentation? I left this open for people to add a free-text response. Here are some worth highlighting, tho...
This question in my 2015 survey may is a followup from question 7 regarding instrumentation. Q8: Do you have any thoughts you'd like to share on instrumentation? I left this open for people to add a free-text response. Here are some worth highlighting, though it was hard to choose since so many ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
How to debug stuff in Oracle APEX
Recently a fine young gentleman, who shall remain nameless (let's call him Jerry), asked for some assistance he was getting with an error in Oracle APEX. He had done all the right things in regard to debugging the problem, but didn't know enough about APEX ...
How to use debug mode in Oracle APEX to find a problem with an Interactive Report.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
What should I know about SQL?
Chris Saxon from the Developer Advocates group asked the following question on Twitter. What three things do you think every developer must know about #SQL ? Reply and share yours! — Chris Saxon (@chrisrsaxon) July 5, 2016 My immediate thought regarded feat...
What should you know about SQL? Expert responses summarised.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Show report tooltip as notification
Last week I described a method to make the tooltip on information more accessible to the end user. Here is how you could make the same information available to touchscreen users. 1) First step, as before , is to define the HTML Expression of the column to i...
Last week I described a method to make the tooltip on information more accessible to the end user. Here is how you could make the same inf...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: Workspace Activity Log
This question in my  2015 survey  relates to built-in instrumentation. Q7. Do you utilise apex_workspace_activity_log (for monitoring/reporting application usage)? Yes (90)  47% No (102) 53% This log table reports details of all page rendering and AJAX proc...
This question in my 2015 survey relates to built-in instrumentation. Q7. Do you utilise apex_workspace_activity_log (for monitoring/rep...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: Instrumentation / Debugging
This question from my  2015 survey  may pique curiosity among some APEX developers. Q6: How do you instrument your code? Hopefully those in the 22% who do not add instrumentation just didn't understand the question. Instrumentation is another term for addin...
Hopefully those in the 22% who do not add instrumentation just didn't understand the question. Instrumentation is another term for adding debugging information to your code. There is plenty of commentary on this topic and done right it can make tracking down problems a breeze.
1
Add a comment...

Scott Wesley

Shared publicly  - 
How to use debug mode in Oracle APEX to find a problem with an Interactive Report.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
What does the community use as prefix for #orclapex application items?
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Application Item Prefix Usage
I was constructing a fresh app for a presentation idea and I came to think about the prefix people use for Application Items in Oracle APEX. I've seen a few variations used, and upon asking the question on Twitter (as a poll limited to 4 options), some came...
What does the community use as prefix for #orclapex application items?
1
Add a comment...
Collections Scott is following
Work
Occupation
Oracle Systems Consultant & Trainer
Skills
Oracle, PL/SQL, Application Express (APEX), Forms, Reports, Database analysis & design, CSS, jQuery, presenting, blogging
Employment
  • Sage Computing Services
    Oracle Systems Consultant & Trainer, 2008 - present
  • Bunnings - Wesfarmers
    Analyst Programmer, 2000 - 2005
    Oracle Forms & Reports, Discoverer, Portal, mod_plsql
  • Fujitsu Consulting
    Analyst Programmer, 2005 - 2007
    Oracle Forms deployment
  • Asgard Wealth Solutions
    Analyst Programmer, 2007 - 2008
    12 month pl/sql contract
Basic Information
Gender
Male
Story
Tagline
Oracle Technologist, husband, father, lover of life - not necessarily in that order ;-)
Introduction
Quick biopsy at about.me/scottwesley
Bragging rights
Best speaker 2011 Perth AUSOUG Conference
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Perth, Western Australia