Recompiling objects in oracle

A pl/sql script to recompile all invalid objects in oracle. Simple but powerfull.

Source:
http://www.orafaq.com/usenet/comp.databases.oracle.misc/2005/02/15/0382.htmy

How to use LIMIT and ORDER BY in sqlite

To get the first 10 in descending order in sqlite

To get the first 10 in ascending order in sqlite

Note: If there are less than 10 entrys in the sqlite database, you will get less than 10 results.

Oracle reverse engineering

To reverse engineere the oracle database, you can use the Oracle data dictionary like follows.