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; |
||
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; |
||