摘要:
/*去重复*/Select xmid,regexp_replace( listagg(name,',') WITHin GROUP (ORDER BY xmid) ,'([^,]+)(,\1)*(,|$)','\1\3')as namefrom t_tablenameWhere yxzt=1 --A 阅读全文
摘要:
declare conNum number; Begin conNum :=250109107; for item in (Select sysid from T_PROJ_DBRW Where cjrid ='system') loop --insert into table_b(a,b,c) v 阅读全文