Create the BFILE directory : bfile « Large Objects « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Large Objects
  3. bfile

Create the BFILE directory

    


SQL> CREATE OR REPLACE DIRECTORY SAMPLE_FILES_DIR AS 'C:\sample_files';

Directory created.

SQL>
SQL>
SQL> drop directory SAMPLE_FILES_DIR;

Directory dropped.








Related examples in the same category

1.Two locators pointing to the same file
2.Insert value to bfile column
3.BFILE File Operations
4.BFILE Comparisons
5.Call BFILENAME to get pointer to a BFILE
6.BFILENAME function