Oracle Data Dictionary Objects for Retriving data for a given schema

1) tables
2) views
3) triggers
4) procedures
5) constraints
6) all of the above mentioned objects

The objects used are:

•  user_tables or tabs
•  user_views
•  user_triggers
•  user_procedures
•  user_constraints
• user_objects

Different SQL queries in the same PL/SQL program vs. design time declared explicit cursors with an association to only one query.