select 'CREATE INDEX ' ||col.table_name||'_PPK on ' ||col.table_name|| '('||col.COLUMN_name ||' DESC)'
from user_constraints con,user_cons_columns col
where
con.constraint_name=col.constraint_name and con.constraint_type='P'
select 'CREATE INDEX ' ||col.table_name||'_PPK on ' ||col.table_name|| '('||col.COLUMN_name ||' DESC)'
from user_constraints con,user_cons_columns col
where
con.constraint_name=col.constraint_name and con.constraint_type='P'
如若转载，请注明出处：https://paper.404sec.com/1434.html