Re: Bfiles and Oracle 8

From: Hardy Merrill <hmerrill_at_my-deja.com>
Date: Wed, 26 Jan 2000 20:45:10 GMT
Message-ID: <86nmcl$sse$1@nnrp1.deja.com>

Does anyone have an example of how to read a text file after it's been stored as a BFile?

TIA.
--
Hardy Merrill
Mission Critical Linux
http://www.missioncriticallinux.com
978-446-9166

In article <387ba52b.95924401_at_newshost.us.oracle.com>, driftwood_at_thebeach.fla.org (DriftWood) wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 14:45:10 CST