开发者

Oracle and programming

开发者 https://www.devze.com 2023-01-26 15:36 出处:网络
I just wanted to know how I can store a picture in oracle d开发者_C百科ata base ;Well, as with anything in oracle, there are a handful of ways to store a photo. You can store it as a BLOB and should b

I just wanted to know how I can store a picture in oracle d开发者_C百科ata base ;


Well, as with anything in oracle, there are a handful of ways to store a photo. You can store it as a BLOB and should be pretty easy to implement loading photos into that type of field. A blob (in 10g) can store up to 8 terabytes in size.

You could also use the READ_IMAGE_FILE and WRITE_IMAGE_FILE functions built into oracle forms and use a RAW datatype as opposed to a BLOB datatype.

References:

Asktom on READ_IMAGE_FILE and WRITE_IMAGE_FILE

Oracle 10g Native Datatypes - Overview of LOB Datatypes

0

精彩评论

暂无评论...
验证码 换一张
取 消