|
|
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 some traffic to ye olde blog (can you tell I’m in the UK this week?)
So most folks [...]
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 but.
SQL Developer is fairly scaled down. You have a few toolbars, several menus, and 2 driving windows [...]
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 spectrum however, it’s pretty safe to assume that at some point you will [...]
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. You must be confusing this with TimeStamp. See, that has the word [...]
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 and look to support those folks doing development, management, modeling, migrations, [...]
No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make [...]
No matter how many monitors you have or how large they may be, sometimes you just need more real-estate for your coding. You can have a whole lot going on in your IDE, and SQL Developer is no exception. Of course you can always close or hide the offending panels and windows, but then it’s [...]
Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is [...]
Hopefully your code is cleaner than what runs through this every morning
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition [...]
Oracle SQL Developer Job Run Log
Starting with 10g and the introduction of DMBS_SCHEDULER, Oracle database began tracking and storing the execution duration of a job. By default this information is kept around for 30 days. You can of course change the logging level and the retention period for the job runs – read the [...]

|
|
Popular Posts