SQL>
SQL> CREATE TABLE lobdemo (
2 key NUMBER,
3 bfile_col BFILE);
Table created.
SQL>
SQL> INSERT INTO lobdemo (key, bfile_col)
2 VALUES (15, BFILENAME('xxxx', 'yyyy'));
1 row created.
SQL>
SQL> INSERT INTO lobdemo (key, bfile_col)
2 VALUES (19, BFILENAME('code', 'file3.c'));
1 row created.
SQL>
SQL> INSERT INTO lobdemo (key, bfile_col)
2 VALUES (20, BFILENAME('code', 'file3.c'));
1 row created.
SQL>
SQL> DELETE FROM lobdemo
2 WHERE key = 20;
1 row deleted.
SQL>
SQL> drop table lobdemo;
Table dropped.
SQL>
SQL>