Skip to content
Koen Aerts
  • Home
  • .NET
  • Java
  • Database
  • Scripting
  • UNIX/Linux
  • Electronics
  • Hacks
  • Arcade1Up Mod
  • RV

Tag: SQL

Parse delimited string into rows

June 29, 2020 Koen Leave a comment

Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012…

Continue Reading →

Posted in: Database, SQL, SQL Server Filed under: Database, SQL, SQL Server

How to achieve the LIKE IN effect in SQL Server

January 20, 2014 Koen Leave a comment

SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there…

Continue Reading →

Posted in: Database, SQL, SQL Server Filed under: Database, SQL, SQL Server

Remove leading zeroes from varchar

November 30, 2012 Koen Leave a comment

The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:

Continue Reading →

Posted in: SQL, SQL Server Filed under: Database, SQL, SQL Server

Concatenate Strings from a Column Into a Single Row

December 20, 2011 Koen Leave a comment

Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a…

Continue Reading →

Posted in: Database, DB2, Oracle, SQL Filed under: Database, DB2, Oracle, SQL

Count Word Occurrences in Oracle String

November 17, 2011 Koen Leave a comment

As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or…

Continue Reading →

Posted in: Database, Oracle, Regular Expression, SQL Filed under: Database, Oracle, Regular Expression, SQL

SQL Developer with a DB2 Database

September 6, 2011 Koen Leave a comment

Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing…

Continue Reading →

Posted in: Database, DB2, Oracle, SQL Filed under: Database, DB2, Oracle, SQL

Catching errors in Oracle

June 16, 2011 Koen Leave a comment

Sometimes there is a need to find out exactly which Oracle errors are occurring in your code, because your application…

Continue Reading →

Posted in: Database, Oracle, SQL Filed under: Database, Errors, Oracle, SQL

Order of predicates in WHERE clause

June 10, 2011 Koen Leave a comment

It is often assumed that the order of the predicates in the WHERE clause of an Oracle SELECT statement does…

Continue Reading →

Posted in: Database, Oracle, SQL Filed under: Database, Oracle, SQL

Regular Expressions in Oracle

Koen Leave a comment

Regular Expressions (RE) are a powerful feature in Oracle. I have found them to be most useful for situations where…

Continue Reading →

Posted in: Database, Oracle, Regular Expression, SQL Filed under: Database, Oracle, Regular Expression, SQL

Tags

.NET Artifactory AutoIt Avatar C# Cloud Container Crystal Reports Database DB2 Docker Electronics Errors Firmware GCR Google Container Repository Groovy Hacks HTML Java Javascript Jenkins JSP Machine Learning Media MongoDB OpenShift Oracle PHP Python Regular Expression Scripting Security Servlet SQL SQL Server UNIX/Linux Virtualization VMware WebSphere Windows WordPress

Links

  • JavaRanch
  • LinkedIn Profile
  • WordPress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2023 Koen Aerts — Escapade WordPress theme by GoDaddy