ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN BDDA1F0D886EF528E0530100007F35BF select distinct x.report_name, x.column_label, x.function_name, x.calculation_column from ( select rr.report_name, rrc.column_label, lower(regexp_substr(rrc.calculation_column,'((\w+\.)?\w+)\s*\(',1,rowgen.column_value,null,1)) function_name, rrc.calculation_column from rx_reports rr, rx_report_columns rrc, table(xxen_util.rowgen(regexp_count(rrc.calculation_column,'(\w+\.)?\w+\s*\('))) rowgen where rr.report_id=rrc.report_id and rrc.view_column_id=-1 and rrc.enabled_flag='Y' and rrc.report_id in (select rrs.report_id from rx_report_stats rrs where rrs.start_time>sysdate-:history_days) ) x where x.function_name not in ( 'concat', 'next_day', 'and', 'or', 'in', 'else', 'when', 'count', 'sum', 'avg', 'min', 'max', 'abs', 'add_months', 'bitand', 'cast', 'ceil', 'chr', 'coalesce', 'decode', 'greatest', 'initcap', 'instr', 'last_day', 'least', 'length', 'lower', 'lpad', 'mod', 'months_between', 'nvl', 'nvl2', 'power', 'regexp_replace', 'regexp_substr', 'replace', 'round', 'rtrim', 'sign', 'substr', 'substrb', 'to_char', 'to_date', 'to_number', 'translate', 'trim', 'trunc', 'upper', 'userenv' ) order by x.report_name, x.column_label, x.function_name Y US RWB Database Functions used by Calculated Columns List of all database functions used by Polaris Reporting Workbench reports, which were executed within the past x history day, to analyze during migration to Blitz Report RWB :history_days 1 10 :history_days Number 365 Y F Journées de l'histoire US History Days