DYNAMIC SQL =========== set serveroutput on set feedback off declare v_sql_stmt varchar2(800); v_instance varchar2(12); begin v_sql_stmt := 'select instance_name from v$instance'; execute immediate v_sql_stmt into v_instance; dbms_output.put_line (v_instance); end; /