Skip to content

Instantly share code, notes, and snippets.

@arbo-hacker

arbo-hacker/uso_fnc_filename.sql

Last active January 23, 2016 05:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arbo-hacker/4e8fff9cf36c99cf3c16 to your computer and use it in GitHub Desktop.
Save arbo-hacker/4e8fff9cf36c99cf3c16 to your computer and use it in GitHub Desktop.
Download ZIP
Uso de funcion FNC_FILENAME
Raw
uso_fnc_filename.sql
-- Uso de funcion FNC_FILENAME ubicada en https://gist.github.com/arbo-hacker/f8385586df6b20ff5419
SELECT FNC_FILENAME('D:\user\Desktop\pafii\leeme.txt', '\', 'txt') nombre_archivo archivo
FROM DUAL;
-- O
set serveroutput on
DECLARE
v_FILENAME VARCHAR2(50);
BEGIN
v_FILENAME := FNC_FILENAME ('c:\user\Desktop\cuentas_bancarias.csv', '\', 'csv');
dbms_output.put_line('El nombre del archivo es '|| v_FILENAME);
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment