Stupid Copy & Paste Tricks

| Feb 22, 2012 02:48 +0000

The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive s…

SQL Developer: Tastes Great, Less Filling?

| Feb 20, 2012 16:49 +0000

The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything bu…

Quick Tip – Comparing Explain Plans with SQL Developer

| Feb 15, 2012 08:00 +0000

I love it when a plan come's together!
SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you fall on that spectr…

Technorati Claim Post

Y8SVVZDHVXVA
Nothing to see here!

Oracle Date Datatype Should be DateTime DataType

| Feb 10, 2012 08:31 +0000

Want to confuse an Oracle database n00b? Ask them if their query takes into account the time component of a date when they code their WHERE blahDate between … AND … logic.
But sir, my dates do not have a time associated with it. Yo…

Your Guide to New Features in Oracle SQL Developer version 3.1

| Feb 8, 2012 08:02 +0000

Did you miss the big news yesterday? We released the next version of Oracle SQL Developer, 3.1. SQL Developer is the IDE for the Oracle database. Millions have downloaded it, more have used it. We try to do one to two releases a year a…