Oracle INSTR在Oracle SQL中向后 [英] Oracle INSTR backward in Oracle SQL

问题描述

我正在尝试在oracle SQL中找到一种方法，以将第一个"/"之后的所有文本从右到第四个"/".我需要在一条SQL语句中执行此操作.

I am trying to find a way in oracle SQL to take all the text after the 1st "/" FROM THE RIGHT to the 4th "/". I need to do this in one SQL statement..

table name: access_log
col name: download
value: Download file:/webdocs/data/groupXXX/case/03_28_54_9_0000011856.pdf

我试图以

case

然后算出多少场比赛?可以做到吗?

then a count of how many matches? can this be done?

推荐答案

select regexp_replace('Download file:/webdocs/data/groupXXX/case/03_28_54_9_0000011856.pdf', 
                      '.*/([^/]+)/[^/]*$', '\1') from dual;

这篇关于Oracle INSTR在Oracle SQL中向后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！