统计ORACLE中带字母的记录

1、统计不为纯数字记录select * from xxx cm where not regexp_like(cm.comm_addr1,'^[[:digit:]]+$')

3、统计存在空格符号的记录select * from dual a where dummy like '% %'

5、统计已123开头的记录-1select * from dual a where substr( dummy,1,3 )='123'

7、统计重复记录select sysdate, count(1) from dual a group by sysdate having count(1) > 1