user5730489
user5730489

Reputation:

Adding images to Oracle SQL Developer

I'm using Oracle SQL Developer and I'm trying to add images from a folder on my desktop to the database. I have a table consisting of:

id          number
Name        varchar 
description clob
thumbnail   blob
image       ordimage
filename    varchar2

I want to be able to add an image to this table.

Is there a way I can manually add them or is their any code tips or help I can get?

Upvotes: 3

Views: 7005

Answers (1)

krokodilko
krokodilko

Reputation: 36127

In Sql-Developer, you neet to click on the table on the right side,
then select "Data" tab, then insert new row (or select existing row),
next click to BLOB column, on the following dialog click to "Load" option,
then select an image and upload it to the table from local disc
See attached picture. enter image description here

Upvotes: 4

Related Questions