Insert value to bfile column : bfile « Large Objects « Oracle PL / SQL






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

Insert value to bfile column

  
SQL>
SQL>
SQL> create table bfile_table(
  2        name varchar2(255),
  3        the_file bfile );

Table created.

SQL> insert into bfile_table values ( 'doc 1', bfilename( 'WROX_DIR', 'my_doc.pdf' ) );

1 row created.

SQL>
SQL> select * from bfile_table;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL>
SQL> drop table bfile_table;

Table dropped.

SQL>
SQL>
SQL> --








Related examples in the same category

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