1 PACKAGE dbms_feature_usage_report AS
2
3 /********************************************************************
4 * FUNCTIONS
5 * display_text, display_html
6 *
7 * DESCRIPTION
8 * Pipelined functions that displays the DB Feature Report in
9 * either Text or HTML format for the inputted DBID and Version.
10 *
11 * For example, to generate a report on the DB Feature Usage
12 * data for the local database ID and Version, the following
13 * statements can be used:
14 *
15 * -- display in Text format
16 * select output from table(dbms_feature_usage_report.display_text);
17 *
18 * -- display in HTML format
19 * select output from table(dbms_feature_usage_report.display_html);
20 *
21 * PARAMETERS
22 * l_dbid - Database ID to display the DB Feature Usage for.
23 * If NULL, then default to the local dbid.
24 * l_version - Version to display the DB Feature Usage for.
25 * If NULL, then default to the current version.
26 * l_options - Report options, currently no options are supported
27 ********************************************************************/
28
29 /* Displays the DB Feature Report in Text format */
30 FUNCTION display_text(l_dbid IN NUMBER DEFAULT NULL,
31 l_version IN VARCHAR2 DEFAULT NULL,
32 l_options IN NUMBER DEFAULT 0
33 )
34 RETURN awrrpt_text_type_table PIPELINED;
35
36 /* Displays the DB Feature Report in HTML format */
37 FUNCTION display_html(l_dbid IN NUMBER DEFAULT NULL,
38 l_version IN VARCHAR2 DEFAULT NULL,
39 l_options IN NUMBER DEFAULT 0
40 )
41 RETURN awrrpt_html_type_table PIPELINED;
42
43 END dbms_feature_usage_report;