Tag: sql

Buzzword Bingo

Looking for that catchy title for your next presentation ? I took the first word from the title of 1000 Oracle OpenWorld presentations, and looked for patterns .  I omitted some obvious terms that are either products or definite/indefinite articles: Oracle Peoplesoft  The How …

AskTOM TV–episode 11

Just a quick note to give the supporting collateral to the latest episode of AskTOM TV. The question I tackled is this one: https://asktom.oracle.com/pls/apex/asktom.search?tag=want-to-retrive-numbers-in-words which was a fun one to answer because it showcases several useful SQL techniques: Using CONNECT to synthesize rows, Using…

Partition-wise join

So just what is a “partition-wise” join ?  We will use a metaphor to hopefully explain the benefit. Let’s say two people, Logan and Shannon, decide to move in together.  If each of them already have an existing residence, they will both have a…

Oracle Code … Not for database people ?

Jump over to the Oracle Code home page and you will see the “mission statement” of the Oracle Code conference series: “Learn from technical experts in sessions for developing software in Java, Node.js, and other languages and frameworks.” You might hence be thinking that…

AskTOM TV episode 8

On AskTOM episode 8, I’ve taken a look at locating the SQL Plan Directives used for a particular query.  Here is the script output from the video if you want to use this for your own exploration SQL> SQL> create table t as 2…

SUM is better than DISTINCT

There is a good chance that (based on this blog post title) that you’re expecting a post on SQL, and that’s understandable. But I’ll come clean nice and early – that was just to lure you in The post is about SUM and DISTINCT,…

Pi Day, March 14

Geeks around the world will be celebrating Pi day, a shameless excuse to put the month before the day like the Americans do so we can talk Mathematics on “3.14” day So what better way to show how cool SQL can be with some…