ORACLE查询所有索引的创建sql

 

 

 

SELECT 'CREATE ' || --DECODE (uniqueness, 'UNIQUE', 'UNIQUE ') ||
'INDEX ' || index_name ||
' ON ' || table_name ||
' (' || listagg (column_name, ', ') WITHIN GROUP (ORDER BY column_position) || ');' AS create_index_stmt
FROM user_ind_columns a
WHERE table_name NOT LIKE 'BIN$%'
GROUP BY table_name, index_name--, uniqueness;