Profile

Cover photo
Scott Wesley
Works at Sage Computing Services
Lives in Perth, Western Australia
170 followers|1,536,761 views
AboutPostsPhotosYouTube

Stream

Scott Wesley

Shared publicly  - 
 
On CSS/jQuery Selector Performance
My post describing the use of a simple selector identifying page spinners was originally going to be about performance, then I learned something I found very interesting. I likened what I learned to Tom Kyte's essay  (Asktom->Resources->Presentations->False...
My post describing the use of a simple selector identifying page spinners was originally going to be about performance, then I learned something I found very interesting. I likened what I learned to Tom Kyte's essay (Asktom->Resources->Presentations->FalseKnowledge.htm) on Correlation vs ...
1
Add a comment...

Scott Wesley

commented on a post on Blogger.
Shared publicly  - 
 
It's something that needs greater awareness, I think I've got a draft post on the same topic. Same goes for dates, particularly if NLS is dd-mon-yyyy as opposed to dd-mm-yyyy
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
On asking questions on APEX forums
I'm a regular contributor to the Oracle APEX forum and something I'd like to note is the amount of questions that possibly wouldn't need to be asked if one had consulted the help of the attribute in question. For example, here someone asked about referencin...
Please supply code/images when asking questions on the forums.
1
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Analytics in APEX Charts - Moving Average
Consider a chart with a trend that might be quite jagged across data points (blue line). What if you would like a smoother version of that line - a moving average , if you will (red line). This stabilises the results, like looking at climate vs weather . Or...
Simple way to add second series to Oracle APEX chart to indicate moving average
1
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
SQL Analytics in every day APEX
Looking for way to apply analytical functions to your APEX applications? I had a classic report where I wanted to dynamically source the column headers from counts in the database (values in brackets). The ability to do this has been a feature of APEX for a...
Looking for way to apply analytical functions to your APEX applications? I had a classic report where I wanted to dynamically source the column headers from counts in the database (values in brackets). The ability to do this has been a feature of APEX for a while, but this was the first time I ...
1
1
Add a comment...
Have him in circles
170 people
Gary Myers's profile photo
Karen Cannell's profile photo
Mathias Magnusson's profile photo
Enteros, Inc's profile photo
Laurent Schneider's profile photo
Swamy Prasad's profile photo
lee hardy's profile photo
Eddie Molina's profile photo
Scott Spendolini's profile photo

Scott Wesley

Shared publicly  - 
 
Improving PL/SQL performance in APEX
One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcut...
One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcuts and dynamic PL/SQL regions.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Training: jQuery and Dynamic Actions in APEX
Sage Computing Services are happy to announce a new 2 day course for Oracle APEX developers. jQuery and Dynamic Actions in APEX This course is designed for APEX developers who know their way around the APEX builder but want to build more interactive & user ...
Sage Computing Services are happy to announce a new 2 day course for Oracle APEX developers. jQuery and Dynamic Actions in APEX. This course is designed for APEX developers who know their way around the APEX builder but want to build more interactive & user friendly applications that are also ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
Please supply code/images when asking questions on the forums.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
#orclapex   #sql  
Simple way to add second series to Oracle APEX chart to indicate moving average
1
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
About CSS Selectors
Recently I saw a simple, accepted answer in the forums that tempted me to provide a small extension to the provided answer. This has since spawned two blog post ideas, here is the first. Background The following question asked how to hide the spinner from a...
How to find the CSS selector to use in an APEX application.
1
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Simple Unpivot
I came across the need for an UNPIVOT today that require fairly basic syntax, so this is me noting it for later. A single column unpivot, not multiple . I had a discrete set of values in local variables that I wanted to use within a merge, so I selected the...
Simple use case for the SQL UNPIVOT statement.
2
1
Add a comment...
People
Have him in circles
170 people
Gary Myers's profile photo
Karen Cannell's profile photo
Mathias Magnusson's profile photo
Enteros, Inc's profile photo
Laurent Schneider's profile photo
Swamy Prasad's profile photo
lee hardy's profile photo
Eddie Molina's profile photo
Scott Spendolini's profile photo
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