select * from cat
select * from tab
select * from user_catalog
select * from user_objects
select * from user_source       -- actual code of procedures
select * from user_tables
select * from all_tables
select * from user_tab_columns
select * from user_views
select * from user_triggers
select * from user_procedures   -- list of procedures
select * from user_tab_privs    -- permissions
select * from user_errors       -- undisplayed error messages
select * from all_errors