Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: postbus@sybrandb.demon.nl (Sybrand Bakker) Newsgroups: comp.databases.oracle.misc Subject: Re: Pictures(JPG) files in ORACLE Date: 6 Jun 2002 05:44:11 -0700 Organization: http://groups.google.com/ Lines: 22 Message-ID: References: NNTP-Posting-Host: 145.13.42.4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1023367451 7453 127.0.0.1 (6 Jun 2002 12:44:11 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 6 Jun 2002 12:44:11 GMT Xref: easynews comp.databases.oracle.misc:82577 X-Received-Date: Thu, 06 Jun 2002 05:51:33 MST (news.easynews.com) pakiyabhai@deadman.com (Pakiya Bhai) wrote in message news:... > i am using oracle9i as the backend/developer2000 as the frontend > > > > ok , i have to create a small catalogue , i need to have a field which > display pictures(RAW I suppose)..... > > NOw the catch , i dont' want oracle to store the pic , all the pics > are stored in say c:\mypics , oracle should only display the picture > from there , should not store it in the datbase, becoz then the size > of the database will increase. > > Is this possible ?? please do not 'suppose' RAW. You need to use the BFILE datatype (described in your documentation) which has been introduced in 8.0 Hth Sybrand Bakker Senior Oracle DBA