Oracle返回截取字符串

 FUNCTION F_GETSUBSTR
  (
      V_STR  VARCHAR2
  )
  RETURN VARCHAR2
  IS
      V_RTNSTR VARCHAR2(100);
  BEGIN
      SELECT SUBSTR(V_STR,INSTR(V_STR,'-')+1) INTO V_RTNSTR FROM DUAL;
      RETURN V_RTNSTR;
  END;