like with regular expressions in oracle

select sum(TERT_COUNT) from gj_chl_tert_sales where  REGEXP_LIKE(TERT_COUNT, '[[:digit:]]');

select sum(TERT_COUNT) from gj_chl_tert_sales where  REGEXP_LIKE(TERT_COUNT, '[^0-9]');

select sum(TERT_COUNT) from gj_chl_tert_sales where  REGEXP_LIKE(TERT_COUNT, '[[:alpha:]]');

select sum(TERT_COUNT) from gj_chl_tert_sales where  REGEXP_LIKE(TERT_COUNT, '[A-Z]');