Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Funcion para obtener nombre de archivo
CREATE OR REPLACE FUNCTION FNC_FILENAME (ruta_archivo VARCHAR2,
barra VARCHAR2,
extension VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
RETURN REGEXP_SUBSTR (ruta_archivo,
'[^' || barra || ']+.' || extension,
1,
1);
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment