查询某个字段都是字母

select * from (
select  case when regexp_like(bank_account_name,'.([a-z]+|[A-Z])') then bank_account_name else null end  cc
from tb_pay_business tt
where tt.uss_trans_date = '20170124'
) bb
where bb.cc is not null