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