大侠能不能说得详细一点啊!
解决方案 »
- 一道关于SQL的面试题,大家帮我看看
- 多个insert语句一次执行我想顺序取回seq怎么搞?
- OCI获取结果集
- 哪个sql更高效
- C++使用OCCI连Oracle10g的错误
- 多个数据库之间存取数据的难! 有一定难度,大家来探讨一下!
- 用START WITH ... connect by prior 时,怎么样得到当前记录的层次?
- 数据库不能启动,大虾救命啊!
- 这条sql语句应该怎么写?
- SELECT replace(lph02,'•','-') FROM lph_file
- jsp连接Oracle 除用thin模式以外 还有什么
- 大家好,我的oracle8.17装完用system/manager进来出现ora-01031:insufficient privileges该什么办
-- 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