oracle 取字符串/后面的字符

[薛果果]

有一个字段 name
gaga/gaga/aa
fa/gda
dfa/gads/ga/ga
比如有这些值，我怎么取这个字段最后一个/后面的值
name
aa
gda
aa

结果这样

[人生无悔]

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

[人生无悔]

--举例如下，你的表自已替换下就可以了
select replace(regexp_substr('gaga/gaga/aa','/[[:alpha:]]*$'),'/','') from dual;

[fw0124]

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 说这个是无效标示符哎