Oracle PL/SQL BFilename Function

The BFilename function returns a BFILE locator for a physical LOB binary file.

The BFilename Function syntax:

bfilename( ‘directory’, ‘filename’ )

Example:

CREATE DIRECTORY files_dir AS '/path/media';

INSERT INTO media_table (id, name)
VALUES (1000, BFILENAME('FILES_DIR', 'logo.jpg'));