Reputation:
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
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.
Upvotes: 4