BFILENAME_UDF

Definition

The function takes the directory name and the filename parameter as a string. Then, it returns a concatenation using the '\'.

The character '\' must be changed to match the Operating System file concatenation character.

PUBLIC.BFILENAME_UDF (DIRECTORYNAME STRING, FILENAME STRING);

Parameters

DIRECTORYNAME STRING

The directory name to be processed as a string.

FILENAME STRING

The filename to be concatenated.

Returns

Returns a string that contains the directory name and filename concatenated by a '\'.

Migration example

Input:

IN -> Oracle_01.sql

SELECT BFILENAME ('directory', 'filename.jpg') FROM DUAL;

Output:

OUT -> Oracle_01.sql

SELECT
PUBLIC.BFILENAME_UDF('directory', 'filename.jpg') FROM DUAL;

Usage example

Input:

SELECT PUBLIC.BFILENAME_UDF('directory', 'filename.jpg');

Output:

directory\filename.jpg