/*
BFILENAME

Example 1
This example creates a directory object, and then inserts a BFILENAME into a table.
*/
CREATE DIRECTORY image_folder AS '/content/images';

INSERT INTO website_images (image_id, image_name)
VALUES (1, BFILENAME(image_folder, 'large_footer.png'));

/*
Example 2
This is an example of using BFILENAME in a SELECT statement.
*/

SELECT BFILENAME(image_folder, 'small_footer.png')
FROM dual;

http://www.databasestar.com/oracle-bfilename

A few examples of the BFILENAME function.

Oracle BFILENAME Function

sql, Oracle

SQL