203759

SELECT 'insert into '||l.TABLENAME||' ('||listagg(lc.column_name,',') WITHIN GROUP(ORDER BY lc.column_name)||') values ('||
listagg(
CASE WHEN lc.num_old_value IS NOT NULL THEN to_char(lc.num_old_value)
  WHEN lc.str_old_value IS NOT NULL THEN ''''||lc.str_old_value||''''
  ELSE 'to_date('''||lc.dat_old_value||''', ''dd.mm.yyyy'')'
END
,',') WITHIN GROUP(ORDER BY lc.column_name)||');'
FROM d_log l JOIN d_log_cols lc ON lc.PID = l.ID
WHERE l.tablename = 'D_DISEASECASES'
AND l.doc_id = :DISEASECASE_ID
AND l.Action = 'D'
AND (lc.num_old_value IS NOT NULL OR lc.str_old_value IS NOT NULL OR lc.dat_old_value IS NOT NULL)
GROUP BY l.doc_id, l.TABLENAME;