Oracle和编程 [英] Oracle and programming

问题描述

我只是想知道如何在oracle数据库中存储图片；

I just wanted to know how I can store a picture in oracle data base ;

推荐答案

与oracle中的任何东西一样，有几种方法可以存储照片.您可以将其存储为BLOB，并且应该很容易实现将照片加载到该类型的字段中.一个blob(10g中)最多可以存储8 TB.

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.

您还可以使用Oracle表单中内置的READ_IMAGE_FILE和WRITE_IMAGE_FILE函数，并使用RAW数据类型而不是BLOB数据类型.

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.

参考文献:

请开启READ_IMAGE_FILE和WRITE_IMAGE_FILE

Oracle 10g本机数据类型-LOB概述数据类型

这篇关于Oracle和编程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！