Re: Bfiles and Oracle 8

CREATE TABLE BFileTest (

    Name	VARCHAR2(64),
    MyFile      BFILE);

CREATE OR REPLACE DIRECTORY testdir AS
'/u02/app/oracle/product/805/test';

INSERT INTO BFileTest VALUES (

    'myfile.txt',
    BFILENAME('TESTDIR', 'myfile.txt'));

In the above example, myfile.txt resides in the directory: /u02/app/oracle/product/805/test

On the server. Received on Tue Jan 11 2000 - 15:51:15 CST