1 2 3 4 5 6 7 8 9 10 11 12 13 14
| With MaTable as
(
select '0777-63-71-79' as number_phone from dual
)
select case when regexp_like(number_phone,'[0,9][0,9][0,9][0,9]-[0,9][0,9]-[0,9][0,9]-[0,9][0,9]') then 1 else 0 end as tst1
, case when regexp_like(number_phone,'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]-[0-9][0-9]') then 1 else 0 end as tst2
, case when regexp_like(number_phone,'[0-9]{4}-[0-9]{2}-[0-9]{2}-[0-9]{2}') then 1 else 0 end as tst3
, case when regexp_like(number_phone,'[0-9]{4}(-[0-9]{2}){3}') then 1 else 0 end as tst4
, case when regexp_like(number_phone,'[[:digit:]]{4}(-[[:digit:]]{2}){3}') then 1 else 0 end as tst5
from MaTable;
TST1 TST2 TST3 TST4 TST5
---- ---- ---- ---- ----
0 1 1 1 1 |
Partager