SELECT T.table_name, LENGTH(TRIM(T.table_name)) FROM user_tables t ORDER BY LENGTH(TRIM(t.table_name)) DESC; SELECT COUNT(t.table_name) 表名超长的表数量 FROM user_tables T WHERE LENGTH(TRIM(t.table_name)) >= 26;
原文：http://www.cnblogs.com/qiushuiblog/p/8012177.html