Profile

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

Stream

Scott Wesley

Shared publicly  - 
 
What does the community use as prefix for #orclapex application items?
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  - 
 
COALESCE vs NVL poll
Saddened but not surprised to see COALESCE lagging behind NVL. Weekend #SQL poll: when mapping binds/columns that could contain nulls to non-nulls do you use: — SQL Daily (@sqldaily) July 1, 2016 Why? Because I think coalesce is a good idea and the modern e...
Why? Because I think coalesce is a good idea and the modern equivalent of NVL. I follow @SQLDaily for useful tips. Oracle SQL evangelist Chris Saxon runs the feed. Posted by Scott Wesley · Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest. Labels: COALESCE, NVL, SQL ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Hide nulls in Value Attribute Pairs report
If you have one record where you want to display multiple columns of information, the 'Value Attribute Pairs - column' report template is pretty nifty. Some of the packaged applications use this within the breadcrumb bar, above a region display selector, an...
If you have one record where you want to display multiple columns of information, the 'Value Attribute Pairs - column' report template is pretty nifty. Some of the packaged applications use this within the breadcrumb bar, above a region display selector, and it looks really tidy.
1
Add a comment...

Scott Wesley

Shared publicly  - 
First JavaScript takes value of P42_ITEM, concatenates a letter and places result in another field. Let's say I entered "X": $s('P42_NEW2', $v('P42_ITEM')+'a'); The value in P42_NEW2 would be "Xa" The PL/SQL code concatenates another letter, passing current value of P42_NEW in and out of session ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: Which browser for development?
Next question in my 2015 survey , how many different ways can we all type "chrome"? Q4: Which browser do you use for development? The first free text question, with a long variety of unique results. I haven't analysed the complete list to get a truer result...
The first free text question, with a long variety of unique results. I haven't analysed the complete list to get a truer result, but the pattern is clear. 3 of the top 5 are Chrome. APEX developers build in Chrome, the application builder is recommended for Chrome, especially during early ...
1
Add a comment...
In his circles
145 people
Have him in circles
170 people
Trent Schafer's profile photo
David Grimberg's profile photo
Patrick Cimolini's profile photo
Kitcraft Cubby houses Australia Wide's profile photo
Dan McGhan's profile photo
Anjo Kolk's profile photo
Daniyar Nurgaliyev's profile photo
Saeed Hassanpour's profile photo
Karen Cannell's profile photo

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

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: Editing Tools
Another preference question in my 2015 survey . Q5: What editing tools do you use for PL/SQL and JavaScript That Jeff Smith fellow should be pretty happy with the top result, but almost half of the "Other" responses said PL/SQL Developer. I used this many y...
That Jeff Smith fellow should be pretty happy with the top result, but almost half of the "Other" responses said PL/SQL Developer. I used this many years ago while SQL Developer was still being born. Since SQL Developer was free and portable, it was an easy selection, though I only use if for ...
1
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Have fun #KScope16
Full and utter credit goes to the gang at CommitStrip, you should check it out. http://www.commitstrip.com/en/2016/06/20/coder-bingo/ I thought a few choice replacements would help Joel Kallman and team rip into what I'm sure will be another stellar set of ...
Full and utter credit goes to the gang at CommitStrip, you should check it out. http://www.commitstrip.com/en/2016/06/20/coder-bingo/ I thought a few choice replacements would help Joel Kallman and team rip into what I'm sure will be another stellar set of Sunday Symposium in Chicago.
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Charting Predictions, al a AskTom
The 'grand algorithm' favoured this particular tweet from Connor McDonald in my 'highlights'. Use regression functions in Oracle to do basic forecasts https://t.co/gaKGHafJaQ — Connor McDonald (@connor_mc_d) June 14, 2016 I found this intriguing considering...
Graphing data using Oracle APEX 5.1 Early Adopter with OracleJET
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
Synchronous Dynamic Actions in APEX 5.1
If you've ever used a PL/SQL dynamic action with the default 'wait for result', you would have seen the following warning if you have the browser console open. Text for bots: Synchronous XMLHttpRequest on the main thread is deprecated because of its detrime...
First JavaScript takes value of P42_ITEM, concatenates a letter and places result in another field. Let's say I entered "X": $s('P42_NEW2', $v('P42_ITEM')+'a'); The value in P42_NEW2 would be "Xa" The PL/SQL code concatenates another letter, passing current value of P42_NEW in and out of session ...
1
Add a comment...

Scott Wesley

Shared publicly  - 
 
APEX Survey Results: What development resources?
The next question in my 2015 survey  was a high level look at what resources developers use to get through your day. On a slightly side note, there was an interesting discussion on the science of preferred vs effective learning styles in this podcast . It r...
The next question in my 2015 survey was a high level look at what resources developers use to get through your day. On a slightly side note, there was an interesting discussion on the science of preferred vs effective learning styles in this podcast. It reminded me of my scuba diving course ...
1
Add a comment...
People
In his circles
145 people
Have him in circles
170 people
Trent Schafer's profile photo
David Grimberg's profile photo
Patrick Cimolini's profile photo
Kitcraft Cubby houses Australia Wide's profile photo
Dan McGhan's profile photo
Anjo Kolk's profile photo
Daniyar Nurgaliyev's profile photo
Saeed Hassanpour's profile photo
Karen Cannell's profile photo
Collections Scott is following
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
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
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