Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate […]
Database, Oracle, Regular Expression, SQL
Count Word Occurrences in Oracle String
As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or string in a varchar. However, […]
Crystal Reports, Java
Bulk Update of DB Password in Crystal Reports
If you need to update the database password for large amount of Crystal Reports, the Crystal Management Console may be too time consuming to change […]
Database, DB2, Oracle, SQL
SQL Developer with a DB2 Database
Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing about it, besides the fact […]
DB2, UNIX/Linux
Cannot start DB2 instance after installation on Linux
You just installed DB2 as non-root user on Linux and when you attempt to start your instance with the db2start command, you get the following […]
Database, Oracle, SQL
Catching errors in Oracle
Sometimes there is a need to find out exactly which Oracle errors are occurring in your code, because your application stacktrace or your log files […]
Database, Oracle, SQL
Order of predicates in WHERE clause
It is often assumed that the order of the predicates in the WHERE clause of an Oracle SELECT statement does not matter or that it […]
Database, Oracle, Regular Expression, SQL
Regular Expressions in Oracle
Regular Expressions (RE) are a powerful feature in Oracle. I have found them to be most useful for situations where you need to quickly find […]