Quickly cloning setid
RahulAgrawal 19 May 2020 15:31
SELECT /*+ INDEX(A) INDEX(R) USE_NL(R) */ rec_group_id,'INSERT INTO '||table_name|| ' Select '|| listagg(decode(a.COLUMN_NAME,'SETID','''TSETID''',a.COLUMN_NAME),',')
WITHIN GROUP (ORDER BY a.COLUMN_ID) || ' from '|| table_name || ' where setid ='''||setid||''';' as INSERT_STMT
FROM all_tab_cols a , PS_SET_CNTRL_REC r
where (decode(substr(r.recname, 1,2),'PS','','PS_')||r.recname=a.table_name )
and setcntrlvalue='00100'
group by rec_group_id,a.table_name,setid