Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
With DBMS_METADATA
you can retrieve complete database object definitions (metadata) from the dictionary by specifying:
DBMS_METADATA
provides the following retrieval interfaces:
OPEN,
SET_FILTER,
SET_COUNT,
GET_QUERY,
SET_PARSE_ITEM,
ADD_TRANSFORM,
SET_TRANSFORM_PARAM,
FETCH_xxx
and CLOSE
retrieve multiple objects.
GET_XML
and GET_DDL
return metadata for a single object and are used in SQL queries and for browsing.
This chapter discusses the following topics:
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|