select table_name from user_tables where table_name like '% TABLENAME%' or table_name=" TABLENAME" tips:表名要大写。