Kaley's (mostly) Oracle Database Blog
Hi! I'm Kaley Crum, Oracle DBA.
Welcome to my (mostly) Oracle database blog.

Archive: Nov 2015

Splitting Rows Out with SQL

Suppose you have the following table:

It looks like this:

001_splitting_rows

But you want it to look like this:

How do you fix this using SQL? Continue Reading

10 Cool Under-Used Oracle Features

The Multi-In List

Cool because it prevents you from writing a long series of “and”s and “or”s

Continue Reading