供参考: 一、写入库: 1、CREATE TABLE html_doc ( docname VARCHAR2(100) PRIMARY KEY, doc CLOB, insertdate DATE DEFAULT SYSDATE) tablespace data02;2、create or replace DIRECTORY htmldocs AS 'C:\html';3、CREATE OR REPLACE PROCEDURE insertHTML (dirname IN VARCHAR2, filename IN VARCHAR2) IS htmlfile BFILE; myclob CLOB; BEGIN INSERT INTO html_doc (docname, doc) VALUES (filename, empty_clob()) RETURNING doc into myclob; -- get a handle to the html file on the OS htmlfile := Bfilename(dirname,filename); -- open the file DBMS_LOB.fileOpen(htmlfile); -- copy the contents of the file into the empty clob DBMS_LOB.loadFromFile(myclob, htmlfile, dbms_lob.getLength(htmlfile)); END insertHTML; 4、EXEC insertHTML('HTMLDOCS', 'test.html'); 检测是否已经将该文件存入到clob字段中。 5、select dbms_lob.getlength(doc) from html_doc; 二、从库读出:(看看这篇文章吧)http://www.chinaunix.net/bbsjh/8/2732.html
一、写入库:
1、CREATE TABLE html_doc ( docname VARCHAR2(100) PRIMARY KEY,
doc CLOB,
insertdate DATE DEFAULT SYSDATE)
tablespace data02;2、create or replace DIRECTORY htmldocs AS 'C:\html';3、CREATE OR REPLACE PROCEDURE insertHTML (dirname IN VARCHAR2,
filename IN VARCHAR2)
IS
htmlfile BFILE;
myclob CLOB;
BEGIN
INSERT INTO html_doc (docname, doc)
VALUES (filename, empty_clob())
RETURNING doc into myclob;
-- get a handle to the html file on the OS
htmlfile := Bfilename(dirname,filename);
-- open the file
DBMS_LOB.fileOpen(htmlfile);
-- copy the contents of the file into the empty clob
DBMS_LOB.loadFromFile(myclob, htmlfile, dbms_lob.getLength(htmlfile));
END insertHTML; 4、EXEC insertHTML('HTMLDOCS', 'test.html');
检测是否已经将该文件存入到clob字段中。
5、select dbms_lob.getlength(doc) from html_doc;
二、从库读出:(看看这篇文章吧)http://www.chinaunix.net/bbsjh/8/2732.html
你可以google下这方面内容
别把字符串直接拼sql里.用变量存储,然后用绑定变量的形式来insert