CODEWITHSUNDEEP
oracle-databasefileblobfile-extension
user2079954
user2079954

Reputation: 479

How to get blob file name or extension

I have an existing Oracle database table in which BLOB field contains files, I want to extract the file name and the extension from the BLOB field,

Any suggestion will be appreciated

Upvotes: 2

Views: 26393

Answers (1)

eaolson
eaolson

Reputation: 15094

BLOBs don't have filenames. They're just a string of bytes. They represent the file contents, not the file itself. So you will have to either create a column and save the filename when the BLOB is inserted (the MIME type is not a bad idea, too), or make one up when you serve it to the user.

Upvotes: 8

Related Questions