Bfilename in Oracle Example

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

In Oracle, BFILENAME Function returns a BFILE locator that is linked with a physical LOB file on the server file system. Below is an example to store a file into a table using BFILENAME in Oracle.

Syntax

BFILENAME function takes two arguments, first is the directory object name and second is the file name.

BFILENAME (directory_object, file_name)

BFILENAME Function Example

In the following example, we will create a table emp_resume and a directory object to store resume file using the BFILE data type and then will insert a record using BFILENAME function.

    1. Create a Table and a Directory Object
    Create Table emp_resume (Empno NUMBER, resume BFILE)
/

Create or Replace Directory MY_DOC as 'C:\Docs'
/
    1. Insert a record into the table using BFILENAME function
    INSERT INTO emp_resume (empno, resume) 
VALUES (7399, BFILENAME ('MY_DOC', '7369_Resume.doc'));

Output

1 row created.

See also: