DBMS_UTILITY.EXPAND_SQL_TEXT

找出查询视图sql对应基表

CDB_PDB@CHF>  set linesize 32767 pagesize 0 serveroutput on
CDB_PDB@CHF>  declare
     original_sql clob :='select * from v_xifenfei';
     expanded_sql clob := empty_clob();
  begin
      dbms_utility.expand_sql_text(original_sql,expanded_sql);
      dbms_output.put_line(expanded_sql);
  end;
  /