SQL> CREATE OR REPLACE DIRECTORY SAMPLE_FILES_DIR AS 'C:\'
2 /
Directory created.
SQL>
SQL> CREATE TABLE bfile_content (
2 id INTEGER PRIMARY KEY,
3 bfile_column BFILE NOT NULL
4 )
5 /
Table created.
SQL>
SQL> INSERT INTO bfile_content (id,bfile_column) VALUES (1,BFILENAME('SAMPLE_FILES_DIR', 'textContent.txt'));
1 row created.
SQL>
SQL> --A BFILE column doesn't care what format a file is stored in.
SQL>
SQL> INSERT INTO bfile_content (id,bfile_column) VALUES (2,BFILENAME('SAMPLE_FILES_DIR', 'binaryContent.doc'));
1 row created.
SQL>
SQL> select * from bfile_content;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL>
SQL> drop directory SAMPLE_FILES_DIR;
Directory dropped.
SQL> drop table bfile_content;
Table dropped.
SQL>