[Home] [Help]
544: l_inst_num IN AWRRPT_INSTANCE_LIST_TYPE,
545: l_bid IN NUMBER,
546: l_eid IN NUMBER,
547: l_options IN NUMBER DEFAULT 0)
548: RETURN awrdrpt_text_type_table PIPELINED;
549: --
550: -- This version accepts a comma-separated list of instance numbers
551: -- No leading zeroes are allowed and no more than 1023 characters total
552: --
554: l_inst_num IN VARCHAR2,
555: l_bid IN NUMBER,
556: l_eid IN NUMBER,
557: l_options IN NUMBER DEFAULT 0)
558: RETURN awrdrpt_text_type_table PIPELINED;
559:
560: FUNCTION awr_global_report_html(l_dbid IN NUMBER,
561: l_inst_num IN AWRRPT_INSTANCE_LIST_TYPE,
562: l_bid IN NUMBER,
632: dbid2 IN NUMBER,
633: inst_num2 IN NUMBER,
634: bid2 IN NUMBER,
635: eid2 IN NUMBER)
636: RETURN awrdrpt_text_type_table PIPELINED;
637:
638: -- ***********************************************************
639: -- awr_diff_report_html (FUNCTION)
640: -- This is the table function that will display the
692: dbid2 IN NUMBER,
693: inst_num2 IN AWRRPT_INSTANCE_LIST_TYPE,
694: bid2 IN NUMBER,
695: eid2 IN NUMBER)
696: RETURN awrdrpt_text_type_table PIPELINED;
697: --
698: -- This version accepts comma-separated lists of instance numbers
699: -- for inst_num1 and inst_num2
700: -- No leading zeroes are allowed and no more than 1023 characters each
707: dbid2 IN NUMBER,
708: inst_num2 IN VARCHAR2,
709: bid2 IN NUMBER,
710: eid2 IN NUMBER)
711: RETURN awrdrpt_text_type_table PIPELINED;
712:
713: -- ***********************************************************
714: -- awr_global_diff_report_html (FUNCTION)
715: -- This is the table function that will display the
908: l_plsql_entry IN VARCHAR2 DEFAULT NULL,
909: l_data_src IN NUMBER DEFAULT 0,
910: l_container IN VARCHAR2 DEFAULT NULL
911: )
912: RETURN awrdrpt_text_type_table PIPELINED;
913: FUNCTION ash_global_report_html(l_dbid IN NUMBER,
914: l_inst_num IN VARCHAR2,
915: l_btime IN DATE,
916: l_etime IN DATE,