In some rare cases you won't want to normalize a table but simply add a list of values in a single cell. This is what VARRAY types are good for.
An old feature but rarely used - the native Oracle compiler which will simply make things faster with almost no effort
Have you ever tried to limit the number of rows in combination with an order by and didn't get the expected result? Here's why and of course the correct way!
Ever wanted to group a number of rows into a single row as a list? This recipe shows you how to do that.