CREATE OR REPLACE DIRECTORY : DIRECTORY « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. DIRECTORY

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>