Oracle execute immediate String.

DECLARE
 t_DAT             DATE;
 t_SQL             VARCHAR2(1000) := 'SELECT SYSDATE FROM DUAL';
BEGIN
 EXECUTE IMMEDIATE t_SQL INTO t_DAT;
 dbms_output.put_line(t_DAT);
END;
    

Kopieren