Skip to content

Instantly share code, notes, and snippets.

@arbo-hacker

arbo-hacker/FNC_FILENAME.sql

Last active January 23, 2016 04:52
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arbo-hacker/f8385586df6b20ff5419 to your computer and use it in GitHub Desktop.
Save arbo-hacker/f8385586df6b20ff5419 to your computer and use it in GitHub Desktop.
Download ZIP
Funcion para obtener nombre de archivo
Raw
FNC_FILENAME.sql
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