Posts in SQL
Regular Expression Anti-Patterns

Oracle Database 10g's new regular expression support is very powerful when it comes to detecting patterns in text. However, you face an interesting problem when it comes to finding text that comes close to matching a pattern while still violating that pattern in some way.

Read More
Creating Pivot Tables

Pivot tables are incredibly useful when writing certain types of SQL queries, because they let you generate rows that do not otherwise exist. Here are several ways to create them. (There is also a CONNECT BY approach that is well-known on the Internet, but that I have never gone back and added to this article). 

Read More
Oracle, SQLJonathan GennickSQL