要使用_，则需要做如下转义
select column_name from user_tab_columns where table_name = ‘SYS_TERMINAL_MAPPING‘ AND column_name LIKE ‘Ia_%‘ escape ‘a‘
oracle转义符
原文：http://www.cnblogs.com/azhqiang/p/4059284.html
