-
Oracle Developer Community Appreciation Day
OK, time for some controversy My ODC appreciation post is about support.oracle.com Now I’m sure there will people in the community just itching to lose their proverbial about how they lost years of their lives waiting on the support response or similar complaint, and since I work for Oracle, they will be just as keen Read more
-
Snapshots from OpenWorld so far
Bridge Run on Saturday Swim in the bay on Monday And the technical content begins ! Read more
-
My OpenWorld theme song
(With apologies to any Simon & Garfunkel fans out there) Hello jetlag my old friend,You’ve come to mess with me again.The bedside clock is stuck on 10 to 4And my eyes are just so bloody sore. The decision to get on that frickin’ plane.Was just insane. Suffering …. my jetlag in silence A few Read more
-
The devastating death PC emoji of doom
So there I am. Sitting at Perth airport. My flight from Perth to Sydney, the first leg on my trip to OpenWorld 2017 is delayed. Of course, delays are not unusual and do not normally bother me. Because I can just flip open my laptop, knock off a few AskTOM questions while I wait. But Read more
-
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 regular expressions to parse text , Using MULTICAST in Oracle 10g Read more
-
Woo hoo … more OpenWorld 17 content
You bewdy! I managed to score myself a couple more mini-sessions at OpenWorld. These will be in The Exchange, the re-designed venue for vendors and demonstrations at OpenWorld. Come along as say Hi. It will be a whirlwind 20 minutes as I try cram as much information into the short time frame as I can. Read more
-
OpenWorld 2017–where is the tech content ?
I can’t actually remember how many OpenWorld conferences I have attended. At a guess it would be around 7 or 8. Every year there is a criticism that there is “not enough technical content”. Well I’m calling “fake news” on that. I can’t remember a time that I’ve struggled to find sessions that I’m interested Read more
-
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 lot of the common items that you find in any household. Read more
-
Updating indexes with partition maintenance
An index is basically a structure that maps keys (values) in columns to the physical location of their corresponding rows in a table. So if you move the rows (ie, change the physical location of a row) then the index entries for those rows need to be updated, or the index is no longer usable. Read more
-
LOBs and tiny typos
This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that stopped SECUREFILE lobs from being created. Here was my incredibly simple test case – create a securefile LOB, and then make sure it’s a securefile. SQL> create table t1 ( b blob ) lob ( Read more
-
Partitioning Guide updated
Just a quick note to say I’ve updated our Getting Started With Partitioning Guide! 9 easy to follow demonstrations to get developers up to speed with handling large databases. Check it out here Read more
-
The AskTOM team at OpenWorld 2017
The AskTOM team will be out and about at OpenWorld in October, so if you are at the conference as a full attendee, or just with a Discovery pass, please come up and say Hi! As well as our session talks, we’ll be doing impromptu discussions and mini-sessions during the week either in the Developer Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 