오라클 정규식 표현
select * from t_reg;
select * from t_reg
where regexp_like(text, '[a-z]');
select * from t_reg
where regexp_like(text, '[A-Z]');
select * from t_reg
where regexp_like(text, '[a-zA-Z]');
select * from t_reg
where regexp_like(text, '[a-z] ');
select * from t_reg
where regexp_like(text, '[a-z] [0-9]');
select * from t_reg
where regexp_like(text, '[[:space:]]');
select * from t_reg
where regexp_like(text, '[A-Z]{2}');
select * from t_reg
where regexp_like(text, '[A-Z]{3}');
select * from t_reg
where regexp_like(text, '[A-Z]{4}');
select * from t_reg
where regexp_like(text, '[0-9]{3}');
select * from t_reg
where regexp_like(text, '[A-Z][0-9]{3}');
select * from t_reg
where regexp_like(text, '[0-9][A-Z]{3}');
select * from t_reg
where regexp_like(text, '[A-Z]');
select * from t_reg
where regexp_like(text, '[[:upper:]]');
select * from t_reg
where regexp_like(text, '^[A-Za-z]');
select * from t_reg
where regexp_like(text, '^[0-9A-Z]');
select * from t_reg
where regexp_like(text, '^[a-z]|^[0-9]');
select * from student
where regexp_like(id, '^M(a|o)');
select * from t_reg
where regexp_like(text, '[a-zA-Z]$');
select * from t_reg
where regexp_like(text, '[[:alpha:]]$');
select * from t_reg
where regexp_like(text, '^[^a-z]');
select * from t_reg
where regexp_like(text, '^[^0-9]');
select * from t_reg
where regexp_like(text, '^[^0-9a-z]');
select * from t_reg
where regexp_like(text, '[^a-z]');
select * from t_reg
where not regexp_like(text, '[a-z]');
select name, tel
from student
where regexp_like(tel, '^[0-9]{2}\)[0-9]{4}');
select name, id
from student
where regexp_like(id, '^...r.');
select * from t_reg2;
select * from t_reg2
where regexp_like(ip, '^[10]{2}\.[10]{2}\.[10]{2}');
select * from t_reg2
where regexp_like(ip, '^[172]{3}\.[16]{2}\.[168]{3}');
select * from t_reg
where not regexp_like(text, '[a-zA-Z]');
select * from t_reg
where not regexp_like(text, '[0-9]');
select * from t_reg
where regexp_like(text, '!');
select * from t_reg
where regexp_like(text, '?');
select * from t_reg
where regexp_like(text, '*');
select * from t_reg
where regexp_like(text, '\?');
select * from t_reg
where regexp_like(text, '\*');
select * from t_reg
where not regexp_like(text, '\?');