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 them from dual. Here is a literal representations
SELECT 'SCOTT' login_id
,'X' alpha, 'Y' beta
In about 22 hours I'll be talking with Oracle Developer Advocate (or the southern/eastern hemisphere AskTom adjunct) Connor McDonald
about one of my favourite part of Oracle, being SQL Analytics.
If you haven't seen any of his YouTube videos
recently, this will be a good chance to catch up and see how easy and practical SQL analytics are, and how you end up with simpler SQL.
I like to think of them like Excel calculations (more...)
Time for my look back on 2015 and what I might aim for in the coming orbit around
the sun. The highlighted word is dedicated to the #flatearth people I've been conversing with on Twitter recently. Wow.
Like many people, part of the reason for doing these sorts of things really what every person should do semi-regularly -> write down your aspirations. I remember being taught goal setting from a young age and I think (more...)
When I first wrote Chapter 9 of my book
, Choosing Processing Options, I knew I still had a lot of research and experimentation to do, particularly regarding the async parameter
. Below is a summary of the outcome of this work and drove a full revision of my original chapter.
Last week I received a printed copy of my book and noticed that unfortunately the first submission of chapter 9 made it into print. Apress (more...)
In reality, this 'add' button could represent any action you would like in a report that would execute PL/SQL upon press of a row level button.
In this example I click on a button in a report to add the row to collection, without submitting the page.
Add Static id to your report region:p2_my_report
Add hidden page item: P2_ADD
Set protected = No if you need to submit the page for other (more...)