Oracle 11g 向表中大欄位插入資料

建立使用者並授權
SQL> create user samp identified by samp;

User created.

SQL> grant connect, resource to samp;

Grant succeeded.

SQL> GRANT CREATE ANY DIRECTORY to samp;

Grant succeeded.

SQL> CONNECT samp

Enter password:

Connected.

建立directory，上傳複製影像檔案到directory目錄

SQL> CREATE OR REPLACE DIRECTORY my_directory_object AS '/tmp';

Directory created.

[root@localhost script]# cp /media/sf_hostmnt/20160831.png /tmp/

[root@localhost script]# chown oracle:oinstall /tmp/20160831.png

建立表，插入資料

SQL> CREATE TABLE print_media

    ( product_id        NUMBER(6)

    , ad_id             NUMBER(6)

    , ad_composite      BLOB

    , ad_sourcetext     CLOB

    , ad_finaltext      CLOB

    , ad_fltextn        NCLOB

    , ad_photo          BLOB

    , ad_graphic        BFILE

    );  2    3    4    5    6    7    8    9   10 

Table created.

SQL> INSERT INTO print_media VALUES (1726, 1, EMPTY_BLOB(),

    'my Oracle', EMPTY_CLOB(), EMPTY_CLOB(),

    NULL, BFILENAME('my_directory_object', '20160831.png'));

1 row created.