JDBC prepared statements are ideal for backend optimization. The resulting SQL does not need to be re-optimized if you are using a parameterized SQL statement. Single parameters or even parameters by name with a single value are quite simple an easy, and you can find examples all over the internet. But if […]

This was written for Oracle 9i use. Oracle 10g has more/better options available.

To allow for diacritic-insensitive searching using Oracle 9i you can create an index with Oracle Text. This gives you many other options as well. There are a few different index types, but this will just show the one. Here […]

For those of you who are moving from mysql, postgres, and other databases to Oracle and get frustrated when you find out there is no auto_increment data type, don’t fret. It isn’t as easy and straightforward, but it is still possible. You can just google your way to find simple code to do […]