upload and query image

I have a image and i want to upload it .

I have created a table and given datatype clob.

so few question

1)how can i upload the image in database.
2)After uploading how can i query in database to see image.

Thanks
sam2929Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
why did you use "character" Large Object ?

Why not a "Binary" Large Object ?

Clob is for storing texts,
Blob is for anything, including images
slightwv (䄆 Netminder) Commented:
Agreed:  You want a BLOB.

The more you can tell us about your app and what the overall requirement is, the more detail we can provide.

1)how can i upload the image in database.
     There are many ways.  If this is a one time thing, I would use DBMS_LOB.LOADBLOBFROMFILE:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_LOB.html#GUID-1C62CBAA-DFB9-444E-9D21-54733A10E95D

Since you mention "upload", I'm thinking website?  Most languages know how to handle BLOBs.

2)After uploading how can i query in database to see image.
   You don't.  You need some software that can interpret the BLOB and decode the image correctly to display it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sam2929Author Commented:
thanks a lot
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.