DECLARE

  l_clob CLOB;

BEGIN

  DBMS_UTILITY.expand_sql_text (

    input_sql_text  => 'with table1 as (                 
          select 1 as field from DUAL 
             union
          select 2 as field from DUAL
             union
          select 5 as field from DUAL
) 
select field from table1 
where 2 = (select min(field) from dual) or
      1 = (select max(field) from dual)',

    output_sql_text => l_clob

  );

  DBMS_OUTPUT.put_line(l_clob);

END;

SELECT
        "A1"."FIELD" "FIELD"
FROM
        (
                ( SELECT
                        1 "FIELD"
                FROM
                        "SYS"."DUAL" "A7"
                ) UNION ( SELECT
                        2 "FIELD"
                FROM
                        "SYS"."DUAL" "A6"
                ) UNION ( SELECT
                        5 "FIELD"
                FROM
                        "SYS"."DUAL" "A5"
                )
        ) "A1"
WHERE
                2 = (
                        SELECT
                                MIN("A1"."FIELD") "MIN(FIELD)"
                        FROM
                                "SYS"."DUAL" "A3"
                )
        OR
                1 = (
                        SELECT
                                MAX("A1"."FIELD") "MAX(FIELD)"
                        FROM
                                "SYS"."DUAL" "A2"
                )