We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Image insert into picture column

jay4
jay4 asked
on
Medium Priority
10,334 Views
Last Modified: 2012-05-04
If i like to insert image or picture into the database:
for instance:
i hv table customer(custnum, custname,...................cust_pic)

what will be my data types and length is for image.
and how can i insert it into database;
what is the data tyoe that use for long characters like aroubd 300 words and more?

"BLOB", "CLOB" what r they?
Comment
Watch Question

Commented:
You can use the BOLb or CLOB data types to store binary data (for example an image, a movie clip etc)

These data types are used to store binary data

I guess The insertion would be possible only thru a front end API

I have done this before using Java

Amit
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CLOB and BLOB are used to store the Large Objects.

CLOB can store upto 4GB of character data, whereas BLOB can store upto 4GB of Binary Data.

You can use the DBMS_LOB package to make transactions on CLOB or BLOB columns.

Author

Commented:
So i cannto insert the image file from my pc, do i need to API?

And catchme the link u have provided confused me, i want simple solution how image are inserted into db and what
data type helps them.
and how can i check my picture are stored in DB?
regards
You can use dbms_lob package (avlb in your database) to store the images. CLOB or BLOB helps them .

>>>Check my pictures stored in db?

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
I WANT TO EXECUTE THE PICTURE IN INTERFACE (IMAGE ITEME)
FROM BLOB DATABASE FIELD USING DEVELOPER6I
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.