How Can Retrieve Object Definitions From Data Dictionary?

1.	How Can Retrieve Object Definitions From Data Dictionary?
Answer» You can use the dbms_metadata package to retrieve object definitions from data dictionary by SPECIFYING the following: Types of object, such as TABLES, indexes or procedures. Optional SELECTION criteria, such as owner or name. Parse items (attributes of the returned objects that are to be PARSED and returned separately) Optional transformations on the output in Extensible Markup Language (XML) or Data Definition Language (DDL) format. You can use the dbms_metadata package to retrieve object definitions from data dictionary by specifying the following:

Answer»

You can use the dbms_metadata package to retrieve object definitions from data dictionary by SPECIFYING the following:

Types of object, such as TABLES, indexes or procedures.
Optional SELECTION criteria, such as owner or name.
Parse items (attributes of the returned objects that are to be PARSED and returned separately)
Optional transformations on the output in Extensible Markup Language (XML) or Data Definition Language (DDL) format.

You can use the dbms_metadata package to retrieve object definitions from data dictionary by specifying the following:

Discussion