Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012…
SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there…
The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:
Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a…
As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or…
Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing…
Sometimes there is a need to find out exactly which Oracle errors are occurring in your code, because your application…
It is often assumed that the order of the predicates in the WHERE clause of an Oracle SELECT statement does…
Regular Expressions (RE) are a powerful feature in Oracle. I have found them to be most useful for situations where…