DBMS_UTILITY.expand_sql_text

DECLARE
  l_clob CLOB;
  i_clob CLOB := q'[   
                   SELECT /*+ optimizer_adaptive */
                   count(CHB_t1.pad), count(CHB_t2.pad)
                   FROM CHB_t1, CHB_t2
                  WHERE CHB_t1.id = CHB_t2.id
                    AND CHB_t1.n = 666
                    AND burn_cpu(CHB_t1.id / CHB_t1.id) = 1 ]';

BEGIN
  DBMS_UTILITY.expand_sql_text(input_sql_text  => i_clob,
                               output_sql_text => l_clob);
  DBMS_OUTPUT.put_line(i_clob);
  DBMS_OUTPUT.put_line(l_clob);
END;