-- The EXECUTE IMMEDIATE can take sql string in CLOB datatype -- The query size can be as large the CLOB datatype size. SET SERVEROUTPUT ON SIZE 1000000; DECLARE v_sql CLOB; v_date VARCHAR2(100); BEGIN v_sql := q'[ SELECT TO_CHAR(SYSDATE,'Day mm/dd/yyyy hh24-mi-ss') FROM DUAL ]'; EXECUTE IMMEDIATE v_sql INTO v_date; DBMS_OUTPUT.PUT_LINE('Today Is -> '||REPLACE(v_date,'-',':')); END; /
23428