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
Messages: 42
Registered: October 2006
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
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: Thu Oct 27 00:28:00 CDT 2016

Total time taken to generate the page: 0.13754 seconds