Skip to Main Content
  • Questions

  • How to Update a blob with a new file in Oracle Database

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Akram.

Asked: December 24, 2015 - 8:54 am UTC

Last updated: December 25, 2015 - 3:08 am UTC

Version: 12c

Viewed 10K+ times! This question is

You Asked

Hi,

I am novice to Oracle Database and I have a requirement for updating a Blob file in a Oracle database with a file from a file system.
This is how my Table looks like

CREATE TABLE MY_FILE_TABLE"
( "ID" NUMBER(19,0) NOT NULL ENABLE,
"MY_FILE" BLOB,
"FILE_NAME" VARCHAR2(255 CHAR) )




and Connor said...

See https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:475021425271

That is for text files, but the same principle applies.

Hope this helps.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here