Oracle storeprocedures

Question

Hi, Since I am new to oracle , please tell me what different ways to find packages , store procedures, triggers ,functions, indexes, tablespaces Thanks

Answer 1

The following statement gives you an overview of all database objects in the current user:

SELECT
object_name,
object_type
        FROM
user_objects;

If you are searching for documentation, you can look at Morgan's Library

Answer 2

You can download Oracle SQL Developer free. This allows you to explore all the objects in your database via a simple interface.