Upload an image into a column with Blob data type on Oracle SQL

Question

I have this table (Image_uploads) with the following columns and data types:

NAME -VARCHAR2(256 BYTE),
MIME_TYPE -VARCHAR2(128 BYTE),
DOC_SIZE -NUMBER,
DAD_CHARSET -VARCHAR2(128 BYTE),
LAST_UPDATED -DATE,
CONTENT_TYPE -VARCHAR2(128 BYTE),
CONTENT -LONG RAW,
BLOB_CONTENT -BLOB.

The column called blob_content is where I want to upload the image to. I used to use an app, but it was decommissioned, now I have to upload using the SQL developer, how do I do this?

Littlefoot · Accepted Answer · 2025-04-07 05:10:09Z

1

insert a new record
double click the CONTENT column so that the pencil icon shows - click it
in the next window, click Load
select a file, click "open"
commit changes

edited Apr 7 at 5:10

answered Apr 6 at 17:33

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Upload an image into a column with Blob data type on Oracle SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related