This code snippit demos how to search strings
-
select
-
v,
-
substr(v,0,instr(v,'_')-1) as first_day,
-
substr(v,instr(v,'_',-1)+1) as last_day
-
from (
-
select '0_32_23_34_324_34_0' as v from dual
-
union all select '1_32_23_34_324_34_0' as v from dual
-
union all select '1_32_23_34_324_34_1' as v from dual
-
union all select '0_32_23_34_324_34_1' as v from dual
-
union all select '0_0_0_0_0_0_0' as v from dual
-
union all select null as v from dual
-
union all select '' as v from dual
-
union all select ' ' as v from dual
-
union all select '_' as v from dual
-
union all select '_2_' as v from dual
-
union all select '2_' as v from dual
-
union all select '_2' as v from dual
-
union all select '__' as v from dual
-
union all select '___' as v from dual
-
union all select '____' as v from dual
-
)
RJM Article Type
Quick Reference