Fear No SQL
My philosophy on development, personal events and announcements.
21c introduced several new iterator syntax. I’ll explore each of them in a series of articles beginning with the (in my opinion) most interesting of them, the PAIRS OF iterator. If you’ve used PL/SQL for a while you’ve probably created simple FOR loops iterating over some set of values, for example: 1 to 10. BEGIN…
Beginning with Oracle Database version 9.0.1, the ALTER SYSTEM command allowed you to add comments to your parameter changes. These comments can be up to 255 characters long. This feature came with the introduction of the spfile. In earlier versions, all parameter changes were made in text files, where you could embed comments with #…
If you’re not into PL/SQL, substitute Jonathan Lewis, Tanel Poder, Maria Colgan, or any other technology great you might respect. Doesn’t even need to be Oracle related. The answer still, quite simply, is yes. First – it’s not a competition. If it were, then yes, I concede to the guy that literally wrote book on…
Several years ago I made a little math joke about a process that performed millions of look-ups and took forever to complete. That joke, just a short one-liner: “Fast Times Many Equals Slow” has since become a bit of a mantra. The problem can be particularly pernicious in that a problematic set of code might…
Oracle gave me an unexpected present for Christmas this year by naming me an Oracle ACE! I’m truly honored to be included in the ranks of so many I’ve read and learned from. Of course I’m also extremely happy to know my efforts to return the favor and share my knowledge and experience has been…
What’s it take to be a good developer? Brains? Of course you have to be able to think. Logic? Sure, you need to have logical constructions. Detailed? Maybe, you do need to pick out the intricacies of requirements. Thorough? Yeah, I’ll give you that. The cause of all bugs is failing to cover some scenario.…
Like everyone else, I make mistakes. While the results can sometimes be unfortunate, it’s also a truth that shouldn’t be ignored. A recurring problem though is that as a designated “expert” sometimes people don’t bother to test what I’ve given them. They just roll with it and then are surprised when their production installation goes…
I’m flying out tomorrow for Collaborate 16. Looking forward to another great conference. I’m presenting again this year. I’ll be speaking on Tuesday, at 2:15 “Why Developers Need to Think like DBAs, Why DBAs Need to Think like Developers” Session 1355 in Jasmine C
A little while ago Oracle announced the winners of the Oracle Database Developer Choice Awards and I was a winner in both of categories I was nominated, SQL and PL/SQL I was surprised and overjoyed when I was notified that I had not only been nominated; but named a finalist. I’m truly humbled by the…
If you haven’t voted yet, please do so soon! Voting ends 3pm US/Pacific time. I’ve been nominated in the SQL and PL/SQL categories https://community.oracle.com/community/database/awards/sql-voting https://community.oracle.com/community/database/awards/plsql-voting
Yesterday Kim Berg Hansen posted a couple entries to his blog about scraping and parsing the Oracle Developer Choice Awards voting pages and building summaries of the results. I’ve been doing something similar since the voting began but took a slightly different approach. I do like the idea of storing them in a table to…
Yesterday I was happily surprised by an email from Steven Feuerstein letting me know I hadn’t responded to my finalist announcement. Well, the reason for that was I never saw it! I’m glad he let me know though, what an honor. I am a finalist in both the SQL and PL/SQL categories. If you’ve enjoyed…
Looking forward to another great conference. I’ll presenting again this year, this time doing two sessions: What an Oracle Developer Ought to Know Why Developers Need to Think Like DBAs, Why DBAs Need to Think Like Developers
Last week was the 5 year anniversary of answering my first question on Experts Exchange and on Monday of this week I answered my 6000th question. With coincidental milestones like that it seems like a good time to reflect on what I’ve accomplished since I started participating. In that time I’ve also published 13 articles,…
First day was unintentionally APEX heavy for me. Not that that’s a bad thing, just sort of surprising to me in hindsight. Saw some really neat apps and ideas with HTML5 and dynamic actions. Also saw some new tools I’ll be checking out to make my own development more productive like aptana studio and apexlib.…