Oracle sql 子字符串长度判断

Oracle sql 子字符串长度判断

1select t.* from   d_table t 
2WHERE  substr(t.col,1,1)='8'   and instr(t.col,'/')>0 
3and length(substr(t.col,1,instr(t.col,'/')))>5;

 字符串的前两位都是数字：

1select * from   d_table t 
2WHERE regexp_like(substr(t.col,1,2), '^[[:digit:]]+$') and length(t.col) > 7 ;