Oracle Database

Description

Dudas técnicas, db scripts y consultas de administración (DBA) y desarrollo (PL/SQL) sobre <strong>Bases de datos Oracle</strong> (Oracle Database 8i, 9i, 10g, 11g..) y la herramienta Oracle SQL Developer

Useful Oracle SQL queries and scripts

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database?

I include in this first post a list of queries, most of them over Oracle metadata dictionary, and extracted from the site Cibermanuales.com.

I encourage everyone that has his own useful queries or scripts to share it answering to this post. The objective is to create a little online repository that we could consult when we are working with the database.