It's been several months since my last blog post, mostly because free time is a scare resource.
But after a few false starts, I've removed the last vestige of "Windows XP" from my home, and upgraded my netbook
to Windows 8. Windows 7 was never an option for this machine and Windows 8 has an afforable XP upgrade option and a simpler set of variants. The "Pro" version which has replaced my "XP Home" adds such goodies as acting as a Remote Desktop server, which was always skipped for 'home' users. I feel all grown up :)
A few weeks back, I saw a mention of an old Tanel Poder post about the uniqueness of ROWIDs
This is an interesting subject as a lot of people expect ROWIDs to be unique, but don't think about how unique that is. While you can't be a little bit pregnant, you can be a little bit unique. Or at least unique only within a specific subgroup.
The only complaint I have about the piece is that it is very DBAish. Lots of moving files around the OS and all those other things that DBAs like to do.
I'm a developer, (more...)
Many moons ago, there existed a bunch of packaged applications for Apex on the Oracle website.
Alas and alack, they were removed and all that exists in their place
is a collection of sample code. They'll be making a comeback in Apex 4.2 where they will be 'prepacked' in the installation and ready to install. You can keep them vanilla, and perhaps get some support from Oracle for them (or maybe just an upgrade path), or you can unlock them and make your own customisations and enhancements.
These packaged productivity apps also got mentioned as part of the cloud. (more...)
I've had the good fortune, in my current role, to be doing a fair amount of PL/SQL development in 11gR2. Boy, it feels good to be actually using up-to-date versions. Being picky, we are on Apex 4.0, rather than 4.1 but that's not a biggie.
One item I've found myself using more and more are the $$PLSQL_UNIT and $$PLSQL_LINE inquiry directives
. I think they are great for logging.
Here's a handy examplecreate or replace procedure fizz_buzz asbegin for i in 1..15 loop if i/2 = trunc(i/2) then if i/3 (more...)
This one is inspired by Jeff Smith's (yes, That Jeff Smith) post "Why I don't follow you
I don't care if you follow me.
Okay, that's not completely true. I hope you didn't stop reading then. What I really meant was that I don't expect all the people that I follow to follow me back.
I read a lot of blogs and articles to learn stuff I don't know about. I'll subscribe to RSS feeds and add people to my Google Plus circles if they write or link to 'quality' material. By quality, I mean (more...)