动态SQL

DECLARE 
v_sql VARCHAR2(10000);
v_cols VARCHAR2(8000);
v_values VARCHAR2(8000);
BEGIN
FOR p IN ( SELECT t.COLUMN_NAME from ALL_TAB_COLS t where t.TABLE_NAME ='NBZ_POLICY_MAIN') LOOP
  v_cols := v_cols ||p.column_name||',';
  v_values := v_values || 'I_POLICY.POLICY_MAIN.'||p.column_name||',';
END LOOP;
v_cols := SUBSTR(v_cols,0,length(v_cols)-1);
v_values := SUBSTR(v_values,0,length(v_values)-1);
v_sql := 'INSERT INTO NBZ_POLICY_MAIN ('||v_cols||') VALUES ('||v_values||')';
dbms_output.put_line(v_sql);
END;