About Scott

Hello Universe.

My name's Scott Wesley and I'm a Oracle Database Consultant & Trainer with Sage Computing Services. We're based in Perth, Australia - the most isolated capital in the world.

Check out my social network for ways to contact me. 

These days I'm a huge fan of most things APEX with a big dash of jQuery. Though I have a rich interest & history with SQL & PL/SQL. I've done hard time on major Forms & Reports applications.

I'm a frequent contributer to the Australian Oracle User Group and enjoy presenting on niche topics. My past presentations are coalesced here.

In 2013 my video course (screencasts with my voice) on Oracle APEX Techniques was published by Packt Publishing.

In 2014 I was recognised as an Oracle ACE.

In 2015 Apress published my book on using jQuery in APEX.

About this blog

My aim with this blog is to become more involved in our Oracle Community and share various snippets I encounter day-to-day and have stored in my back catalogue of randomness. No doubt I'll want to share my perspective on various Oracle news and I'll have the occasional insight and will to post something larger.

When deciding on a name for this blog I had a few choices:

  • Use my own name - for some people I think that works rather well. Some people gathered some form of identity before they started blogging, so their name can become similar to a brand.
  • Refer to an Oracle product - I didn't want to pin myself to one particular product. While I consider myself a PL/SQL developer, I also use Forms, Apex etc. Over time all of us might migrate into other product lines. If I so chose to rabble about something Oracle, I wouldn't feel out of place.
  • Do something else - I like to be different. There are some successful blogs out there (Oracle and otherwise) whose name doesn't obviously reflect the content involved.
I originally chose Triangle Circle Square because I can reflect on my training in budo. When you meet some form of adversary, we need to confront them in a strong triangular stance. For many techniques we'd pivot around in some form of circular movement then finish in a strong squatting stance that whose posture resembles a square. I was able to translate the challenges I faced in the Oracle world to this analogy.

It was suggested it was a little far removed; and while it has served me for around 30 months, I found another term I feel encapsulates the style of my blog and my approach to a number of facets of life - grassroots oracle.

I think that whatever the challenge, we should approach it with a good a fundamental understanding. Conversely, instead of fighting fires - we should be tackling the root cause of an issue. This goes for all walks of life. Develop good grass roots in a given topic, and it should thrive - pardon the pun ;-)

My inaugural post detailing my original blog title may be found here. I've also retained a portion of the original artwork in the new header - it's from a painting by a fellow who lived on the island known as Japan in the 18th century. Much can be interpreted from this philosopher's doodling - the rough English translation of this painting is "Universe". David Suzuki comments on it well, but many like to contemplate for themselves and build their own interpretation.

You might consider the use of grass roots understanding to use Oracle effectively, and solve the various problems using the triangle circle square analogy.

By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest.
- Confucious


Steve Shore said...

I'm not really an Oracle developer nor an Apex person. I've been doing Mainframe (COBOL, Assembler, JCL - real cutting edge stuff eh?) for like 25 years. I have a client that wants me to take a mainframe file ( yes a flat file, no key, this system was written in 1985) and create an Apex app. I've been through lots of tutorials and I understand how to do it. Problem is, the file has 8 million records (yes a flat file, no key but I can create a unique key in Apex). All of the examples I see display all records in a tabular form and allow you to scroll to the next page. They allow you to filter records but with 8 million records, not real practical. Ideally what I'd like to do is initially display a search screen that allows users to a couple of search options and then a second screen that displays records found. Any suggestions on finding an example or tutorial that does this? Thanks

PS good luck with Austrailias current heat wave

Steve Shore said...

PS client is on Apex 3.2

Scott Wesley said...

Hi Steve,

Sorry for the delayed reply.

As you may have found, tutorials start at the product documentation itself. An example in 4.2 originally in 3.2

Yours is really a database design issue. I did a presentation on Oracle Text indexes in 2010 that you may find relevant and interesting.

Starting points hopefully - but is certainly a good idea for a blog post. I'll had it to the list ;-)

Anonymous said...

Hi Scott,

I like your web page so much. Its cool to look at and refreshing to the
eyes and mind. Can tell me what software did you use to created this page? Is Apex 4.2 capable of creating page like this?

Thanks a lot,


Scott Wesley said...

Hello "zxy",

For this blog I rely solely on the tools that Google provide through blogger. I do use a syntax highlighter for my code.

It is certainly possible to re-produce a site like this using APEX, in fact there is a platform out there you can use
And Jari Lane is a great example of a blogger using APEX to deliver the goods.

If I had the time I would love to publish using APEX instead. I think it would be rewarding and would teach me a lot - but there are a few other projects higher on the list for me at the moment.

taheri971 said...

Hi scott
i find javascrip code from this link

and i want use this code for get picture from client webcam and save to my oracle apex table

how can it?
please help me

Scott Wesley said...

Hi Taheri971,

The best place for this sort of question is community.oracle.com, using the APEX space.

There are a lot of questions between here and what you're looking for, so be prepared to offer what you've tried so far to get it to work.