贾小黑的博客

批量表名 大写改小写SELECT concat( 'rename table ' , TABLE_NAME , ' to ' , LOWER(TABLE_NAME) ,' ;' ) AS 'SQL'FROM information_schema.TABLES t WHERE TABLE_SCHEMA = 'xxxxxx';批量列名 大写改小写SELECTconcat( 'alter table ' , TABLE_NAME , ' change column

ORACLE 正负数分开排序