AprilandJake.com

I was running an SQL query today and it was sooooo slow. So slow, in fact, that it never returned. I asked the DBA, Reed, who built the table what might be up, and he informed me that it was not indexed. And proceeded to show me some cool stuff I could do to actually get my query to return. In the end, it was a comparison between the "not in" operator and a "left join".

On Ubuntu 9.04, Jaunty, Compiz comes running out of the box on the mid-level preset for desktop effects. These effects and generally beautiful and pleasing, but a couple of the apps that I use are Java-based and have some compatibility issues with Compiz. At least for my apps, I've found a way around this issue.

There's no pre-defined method to count the number of occurrences of a certain character in a database table column using SQL. There's a quick and dirty way to get it done however. In my case, I wanted to figure out how many lines existed in a column that held address information, separated by line breaks. Here's a spot of code that helped from the friendly neighborhood DBA, Reed.

In Oracle's SQL Developer 1.5 tool, there seems to be a crazy bug where one can't see the full timestamp value (including time) by default. You can change this by running this awesome piece of code...

All over the net, there are questions asked about running Crystal Reports in Linux. This isn't a solution for running Crystal in Linux per se, but running Crystal as lightweight as possible on a Linux host machine. This means, run a VM, install Crystal, and use a small Oracle client.

The goal:
Create a history audit tool that:

• Fires automatically


• Tracks only selected fields


• Categorizes those fields


• Saves old vs. new data

Issues we'll cover:

• Interceptor config


• Data types


• Dependency Injection


• Alternate EntityListeners

One solution:
The one option that I found that met all these requirements was the Hibernate Interceptor. There may be better alternatives for you if your requirements differ.

Sometimes you have a large database schema and a lot of tables that you're not sure what they contain. You do know, however, the nature of the data'ific needle that you're trying to find in your schema'ific schema. Oracle provides some cool dictionary tables that might help you in your quest.

Since my work recently relieved us of our Toad licenses, I've gotten to know and love SQL Developer. I used it back in the day of pre-version 1.0 Raptor days, but have recently picked it back up of necessity. I like it for the most part and use it with pleasure for the most part.

(Note: ICS-specific) LDAP connectivity for SQL Developer is the preferred method for connecting to databases at ICS. Here's how to get the job done.

For downloading and installing SQL Developer, see a separate tutorial. Note that versions of SQL Developer prior to 1.5 do not support LDAP connections.