自己写函数吧,很麻烦:如下转换成varcharcreate table test(a number,b long); delete from test; insert into test values(1,12432433425); commit;create or replace function long_2_varchar(pi_a number) return varchar2 as l_long long; begin select b into l_long from test where a=pi_a; return substr(l_long, 1, 4000); end;select long_2_varchar(1) from test;
delete from test;
insert into test values(1,12432433425);
commit;create or replace function long_2_varchar(pi_a number) return varchar2
as
l_long long;
begin
select b into l_long from test where a=pi_a;
return substr(l_long, 1, 4000);
end;select long_2_varchar(1) from test;