oraclerecipes

Welcome! oraclerecipes.com is a site where we collect the best and most useful recipes for common problems and challenges you might have with your Oracle database.

You are not just able to comment on a recipe, but also post your own recipe!


Advertising


Most Commented


Latest Recipes


Create a table out of nothing

sql table out of nothing

Working with Arrays - VARRAY

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.

Faster PL/SQL Code by using native compiler

An old feature but rarely used - the native Oracle compiler which will simply make things faster with almost no effort

Limit number of rows in a sorted query

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!

Aggregate multiple rows into one as a comma-delimted list

Ever wanted to group a number of rows into a single row as a list? This recipe shows you how to do that.

Show all recipes