ORACLE Datatypes

From: <tmurrayiii_at_aol.com>
Date: Mon, 23 Aug 1999 18:14:39 GMT
Message-ID: <7ps323$edm$1@nnrp1.deja.com>

HI,

I have some visio (binary) diagrams which I would like to store in our oracle 8i database. Is a BLOB format the best way to go? If so, how do I setup the table to use a blob, and how do I insert a blob?

Additionally, can one store a pointer in the db to a file on disk. If so, would I just want to use a varchar datatype, which contains the path and filename? Or is there a special type of datatype for this type of pointer?

Thanks in advance for you help!!!

Tom.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 23 1999 - 13:14:39 CDT