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, '\?');
'IT > Oracle' 카테고리의 다른 글
| 우분투에 오라클 설치 및 셋팅 (0) | 2018.08.09 |
|---|---|
| 오라클 hr 계정 만들어서 사용하기 (0) | 2018.08.09 |
| 오라클 View, 단순뷰, 복합뷰, inline view, view 조회 및 삭제, Materialized View(MVIEW) (0) | 2018.08.09 |
| 오라클 profile 생성, 확인, 적용, 삭제, grant, revoke, role (0) | 2018.08.09 |
| 오라클 인덱스 조회, 모니터링, rebuild, invisible, (0) | 2018.08.08 |