oracle 查询所有表中以TICKET开头，TYPE结尾的表，同时不显示末尾为数字的时间表 SELECT * FROM user_col_comments WHERE COLUMN_NAME like 'TICKET%_TYPE' AND substr(table_name,-1,1) not in ('0','1','2','3','4','5','6','7','8','9')
