Home » SQL & PL/SQL » SQL & PL/SQL » Keep .doc in Database
Keep .doc in Database [message #203033] Mon, 13 November 2006 11:38 Go to next message
renafi
Messages: 42
Registered: October 2006
Member
Hi. How can i keep a .doc in my oracle databse? I heard is has something to do with a CLOB variable.. but i have no idea. Any help? thanks

PS: now, while i'm on it, how can i keep ANY file in the database? Razz
Re: Keep .doc in Database [message #203043 is a reply to message #203033] Mon, 13 November 2006 12:26 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you want to store a .doc file in the database, you should use a BLOB (Binary Large Object). As the name suggest, BLOB's are used for files which are in binary format. If you wish to store a plain text file in the database you can use a CLOB (Character Large Object).

You should read over the documentation for LOBs.
Previous Topic: XML file Synchronization
Next Topic: devide a full name of a person into 4 seperate names
Goto Forum:
  


Current Time: Sat Dec 03 18:01:34 CST 2016

Total time taken to generate the page: 0.06843 seconds