Long -> lob , to_lob 转换,迁移
create table t1 (c1 number,c2 long);create table t2 (c1 number,c2 clob);insert into t2 select c1, to_lob(c2) from t1 ;create table t2 as select c1, to_lob(c2) c2from t1 ;[@more@]
BLOB对象的读出,utl_file.put_raw
BLOB对象的读出http://blog.csdn.net/wangdeng1314/archive/2010/05/20/5612757.aspxutl_file.put_raw 可以写二进制文件。[@more@]