Uniqualize rows of any table using ora_te

One of the cool ways to use my small template engine for Oracle (ora_te). procedure uniqualize_rows_no_commit( a_table_name in varchar2 ) as v_clob clob; v_te_uniq ty_te; begin v_te_uniq := ty_te.compile_named( q’# delete from {$table_name} where rowid in ( select rowid from ( select rowid , row_number() over ( partition by {%for cur:1|join(‘,’)%}{$column_name}{%endfor%} order by null ) […]