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;