有关blob的资料在那里找 oracle数据库使用指南,或oracle开发文档 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 到處都有精華和FAQ其他人的貼子書籍網絡一個使用BOLB例子-- connect sample/...drop table docs;create table docs ( id number, title varchar2(4000), bfile_text bfile, blob_text blob, text1 char(1), text2 char(1) );insert into docs ( id, title, bfile_text, blob_text ) values ( 1, 'a short essay', bfilename ( 'SAMPLE', 'Test.doc' ), empty_blob() );commit;-- Populate the BLOB column with an exact copy of the BFILE columndeclare v_length integer; v_bfile_text bfile; v_blob_text blob;begin select bfile_text, blob_text into v_bfile_text, v_blob_text from docs where id = 1 for update; v_length := Dbms_Lob.GetLength ( v_bfile_text ); Dbms_Lob.Open ( file_loc => v_bfile_text ); Dbms_Lob.LoadFromFile ( dest_lob => v_blob_text, src_lob => v_bfile_text, amount => v_length, dest_offset => 1, src_offset => 1 ); Dbms_Lob.Close ( file_loc => v_bfile_text ); update docs set blob_text = v_blob_text where id = 1; commit;end;/select Dbms_Lob.GetLength ( bfile_text ) l_bfile, Dbms_Lob.GetLength ( blob_text ) l_blob from docs;-- both should be 19456 characters Oracle使用游标放回结果集出现怪异问题 plsql developer求助 over 疑问 ORA-01475: 必须对光标重新进行语法分析来改变赋值变量的数据类型. Oracle 10g安装问题 oracle版的牛人们,帮小弟我解决个问题~ 面试的时候遇到oracle问题,不吐不快 vb中连接oracle9.2 的问题 数据库外键该不该使用? 如何在建表时候指定其数据的变化不引用回滚段. group by 的语句有错 带条件的联合查询,数据库是先联合两个表,还是先用条件过滤再联合两个表?
其他人的貼子
書籍
網絡一個使用BOLB例子-- connect sample/...drop table docs;
create table docs (
id number,
title varchar2(4000),
bfile_text bfile,
blob_text blob,
text1 char(1),
text2 char(1) );insert into docs ( id, title, bfile_text, blob_text ) values
( 1, 'a short essay', bfilename ( 'SAMPLE', 'Test.doc' ), empty_blob() );
commit;-- Populate the BLOB column with an exact copy of the BFILE columndeclare
v_length integer;
v_bfile_text bfile;
v_blob_text blob;
begin
select bfile_text, blob_text
into v_bfile_text, v_blob_text
from docs
where id = 1
for update;
v_length := Dbms_Lob.GetLength ( v_bfile_text ); Dbms_Lob.Open ( file_loc => v_bfile_text );
Dbms_Lob.LoadFromFile (
dest_lob => v_blob_text,
src_lob => v_bfile_text,
amount => v_length,
dest_offset => 1,
src_offset => 1 );
Dbms_Lob.Close ( file_loc => v_bfile_text ); update docs set blob_text = v_blob_text
where id = 1;
commit;
end;
/select
Dbms_Lob.GetLength ( bfile_text ) l_bfile,
Dbms_Lob.GetLength ( blob_text ) l_blob
from docs;-- both should be 19456 characters