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.

No comments:

Post a Comment

Please Provide your feedback here