This little web sites provides a couple of Oracle recipes which hopefully help to get a solution to a real problem as quickly and easily as possible.
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.
Having a list of tables in a database can help you to get a picture of what's there. Here's how you can do that.
Ever wondered what Oracle function you can use? There's a data dictionary telling you about every available function including some additional information.
Want to make sure no one creates code errors in a database? Check this article for an easy monitoring solution.
You want to make sure no one connects to your production database using Excel, Sqlplus or another tool?
Want to let management know how well your database is running?
You'll definitely have to use indexes if you want your database to perform but having too many indexes isn't good either. Save some storage and make your database faster by removing unnecessary indexes.
Got any questions? A good idea for a new Oracle recipe? Drop us a message and we'll try to get a hold on you as soon as possible.