ORACLE OBJECTS Search [PROCEDURE] [PACKAGE] [FUNCTIONS]

The following tables provide DB structure details:

1. user_objects - It lists all the objects owned by logged in db user.
2. ALL_OBJECTS - It describes all objects accessible to the current user.
3. ALL_SYNONYMS - It describes the synonyms accessible to the current user.
4. ALL_PROCEDURES - It lists all functions and procedures.