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!
Create a table out of nothing
sql table out of nothingWorking 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 effortLimit 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.
