I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
Database Stuff

I travel quite frequently for my job. Number one on my list of ‘must have things’ on the road is a Navigation device. This used to be my trusty Garmin, but now thanks to my new Android device, I have Google Maps. There have been times and places where I don’t have the device available – either the GPS satellites cannot be acquired or i’m in D.C. where the accuracy of the positioning seems artificially…

Database Stuff

In an earlier post, I discussed the merits and deficiencies around using the * syntax in a SELECT statement. I have been using this topic as a way to bring up lively discussions while doing database tools demos for our SQL and Oracle customers. I must admit I am extremely dismayed by the amount of Senior level folks who do not understand why this is not an ideal way to write queries. In a lot…

Database Stuff

I had to check out Brent’s LinkedIn account to see just how long he had been at Quest. Wow, 2.25 years. It was only about a year ago that I became aware of Brent’s presence. I actually can’t remember if I stumbled across his blog first or heard his name mentioned in a conference call. Ahhh, as I type this, I now recall how I ‘met’ Brent. Via Twitter. @BetsyLM had compiled a list of…

Personal Tech

After waiting nearly six weeks to receive my Incredible, I can honestly say it WAS worth the wait. Updated: Friday, July 16, 2010 Two Weeks Later… I have had very few problems with the phone and have been able to successfully navigate around them. The very first problem was with activation. Phone would not activate on its own. First Verizon support guy would not activate my phone. Second Verizon support guy, Chris, did activate it…

Toad® Stuff (Retired)

This is not a volley in the RDMBS wars. This is a quick cheat sheet for getting started using Toad for SQL Server if you are already used to using Toad for Oracle. Pages not Windows Toad for Oracle is a classic Windows application that utilizes a classic MDI presentation. Toad for SQL Server uses ‘Document Tabs’ for each ‘Window’ you have open in the application. Object Explorer vs Schema Browser Of course a ‘Schema’…

Personal Tech

Updated 3/16/2014, Full disclosure: I picked up a 13″ MacBook Air this week I’m not sure I want it anymore. No, I do still want one, but the annoying voice in the back of my head has all but shut up. I know what you’re thinking, somewhere an angel has just lost it’s wings because I’m being selfish. As a professional geek, I’m supposed to buy this stuff and talk about it to everyone I…

General

The circle of people I follow in the IT world have recently been blogging about their travel habits. It’s no accident – companies are investing large amounts of money in business travel now. Hopefully if you meet someone face to face, they will listen to you next time you randomly call and ask for their attention in some matter. Yes, I know, that’s a bit blunt, but you’re naive to think a vendor is coming…

General

We went from ‘Full of Food, Myself, and _______’ to ‘140,000 Characters or Less’ – hopefully an obvious tongue-in-cheek reference to Twitter. I’m not 100% happy with this title either, but I also recognize the futility of spending multiple brain cycles trying to come up with something catchy, and probably at the end of the day do nothing to bring people to my blog. So, I’m going to focus on content, content, and whatever makes…

General

My friends, family, and colleagues are frequently asking me why I do Twitter. Or to be honest, when I ask if they are on Twitter, their response is less than enthusiastic. In fact, the most frequent response I get is either Rolling of the eyes, OR “I don’t need to tell people what I had for lunch yesterday.” I originally signed on to Twitter because I was morbidly curious. You can only hear something about…

Database Stuff

I think it’s safe to say that the Twitter hashtag #SQLHELP has been an unqualified success. Why do our SQL Server friends have such a vibrant community on Twitter while us Oracle folks seem to be a bit resistant to all of this Web2.0 stuff? That’s largely a rhetorical question, although my gut tells me it’s a generation/age gap issue… Anyway, I’m making it my personal mission to bring a similar construct to the Oracle…