--举例如下,你的表自已替换下就可以了 select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;
select substr('dfa/gads/ga/ga', instr('dfa/gads/ga/ga', '/', -1) + 1) from dual; 先利用instr反向查找/的位置,然后substr取子字符串
--举例如下,你的表自已替换下就可以了 select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual; regexp_substr 说这个是无效标示符哎
SQL> select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;RE -- aa
--方法1: SQL> with tmp as 2 ( 3 select 'gaga/gaga/aa' name from dual union all 4 select 'fa/gda' name from dual union all 5 select 'dfa/gads/ga/ga' name from dual 6 ) 7 select replace(regexp_substr(name,'/[[:alpha:]]*$'),'/','') name from tmp;
NAME ---------------------------- aa gda ga
--方法2: SQL> with tmp as 2 ( 3 select 'gaga/gaga/aa' name from dual union all 4 select 'fa/gda' name from dual union all 5 select 'dfa/gads/ga/ga' name from dual 6 ) 7 select substr(name, instr(name, '/', -1) + 1) name from tmp;
--举例如下,你的表自已替换下就可以了
select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;
先利用instr反向查找/的位置,然后substr取子字符串
select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;
regexp_substr 说这个是无效标示符哎
SQL> select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;RE
--
aa
--方法1:
SQL> with tmp as
2 (
3 select 'gaga/gaga/aa' name from dual union all
4 select 'fa/gda' name from dual union all
5 select 'dfa/gads/ga/ga' name from dual
6 )
7 select replace(regexp_substr(name,'/[[:alpha:]]*$'),'/','') name from tmp;
NAME
----------------------------
aa
gda
ga
--方法2:
SQL> with tmp as
2 (
3 select 'gaga/gaga/aa' name from dual union all
4 select 'fa/gda' name from dual union all
5 select 'dfa/gads/ga/ga' name from dual
6 )
7 select substr(name, instr(name, '/', -1) + 1) name from tmp;
NAME
----------------------------
aa
gda
ga