Oracle已经建议使用lob代替long, 但旧应用中还有一些long类型, 在insert into select from中无法使用
long to long
declare
test_type long;
begin
select detail into test_type from table_long;
insert into table_long2(detail) values(test_type);
commit;
end;
/long to lob
insert into table_clob(detail) select to_lob(detail) from table_long; note: cannot use LOB locators selected from remote tables
参考:
1.
http://www.itpub.net/304707.html2. Oracle SQL Reference