How to get BLOB file extension [message #462567] |
Fri, 25 June 2010 00:55 |
|
There are different types of files loaded in databse BLOB type column, .doc, .xls, .pdf or even .xlsx and .docx. Now, I need to download these file and open it. The problem is how can I determine what file extension these files have.
Help needed from you guys.
|
|
|
|
|
Re: How to get BLOB file extension [message #462577 is a reply to message #462570] |
Fri, 25 June 2010 01:32 |
|
Michel Cadot
Messages: 68686 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If you want the extension this is because you want to know if it an Excel, PDF, Word... document, isn't it?
So store this name of the application in a column or store the extension, as you want.
Oracle can't know the extension, so you have to tell it.
Regards
Michel
[Updated on: Fri, 25 June 2010 01:33] Report message to a moderator
|
|
|
|
|
|
|