Two locators pointing to the same file : bfile « Large Objects « Oracle PL / SQL






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

Two locators pointing to the same file

  
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>








Related examples in the same category

1.Create the BFILE directory
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