从查询中删除/反斜杠以在oracle中获取有效数据

通过我的最新查询,我得到的数据如下 ABDD_1037/ .但我不想要有 / 在里面。

我尝试了以下查询,但不起作用

SELECT TO_CHAR(RJ_INTRACITY_LINK_ID) AS SPAN_ID, 
       TO_CHAR(RJ_MAINTENANCE_ZONE_CODE) AS  MAINT_ZONE_CODE
  FROM NE.MV_SPAN@DB_LINK_NE_VIEWER
                  --   FROM  APP_FTTX.span@SAT
 WHERE LENGTH(RJ_INTRACITY_LINK_ID) > 8 
   AND LENGTH(RJ_INTRACITY_LINK_ID) < 21            
   AND INVENTORY_STATUS_CODE = 'IPL' 
   AND RJ_MAINTENANCE_ZONE_CODE = 'INUEABDD01'
   AND NOT REGEXP_LIKE (RJ_INTRACITY_LINK_ID,'_(9|31|4|7|_____|U|[\/]$)','i')
 MINUS         
SELECT TO_CHAR(LINK_ID) AS SPAN_ID,
       TO_CHAR(MAINTENANCEZONECODE) AS MAINT_ZONE_CODE
  FROM TBL_FIBER_INV_JOBS
 WHERE SPAN_TYPE = 'INTRACITY'
   AND MAINTENANCEZONECODE = 'INUEABDD01'
 ORDER BY 1;

更新

如果我注释整个正则表达式行,我会得到所有不需要的数据,如下所示

`ABDD_0102_U`, `ABDD_1037/`,`ABDD_3102`, `ABDD_4003`, `STHU_9032`,