SQL>
SQL> CREATE TABLE facebook (
2 name VARCHAR2(80),
3 photo BLOB,
4 directions CLOB,
5 description NCLOB,
6 web_page BFILE);
Table created.
SQL>
SQL> CREATE DIRECTORY bfile_data AS 'c:\xxx';
Directory created.
SQL>
SQL> DECLARE
2 web_page BFILE;
3 BEGIN
4 DELETE FROM facebook WHERE name='Tannery Falls';
5
6 web_page := BFILENAME('BFILE_DATA','Tannery Falls.htm');
7
8 INSERT INTO facebook (name, web_page) VALUES ('Tannery Falls',web_page);
9 END;
10 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table facebook;
Table dropped.
SQL> drop directory bfile_data;
Directory dropped.
SQL>