About OracleRecipes.com

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.


Latest Oracle recipes on OracleRecipes.com

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.

Get a list of all available Tables in your Oracle database

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.

What Oracle Functions are there

Ever wondered what Oracle function you can use? There's a data dictionary telling you about every available function including some additional information.

Monitor Database errors

Want to make sure no one creates code errors in a database? Check this article for an easy monitoring solution.

Prohibit Excel from connecting to your database

You want to make sure no one connects to your production database using Excel, Sqlplus or another tool?

Determine Database Uptime

Want to let management know how well your database is running?

Find unnecessary indexes

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.
RSS Feed
« Previous123Next »


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.

Copyright © 2010 - 2017 by OracleRecipes.com
Oracle © is the registered trademark of Oracle Corporation.