将Long type data 转化为char type......

sql>create table t1(c1 long);

Table created.

sql>insert into t1 values('aaaabbbcccc789');

1 row created.

sql>commit;

Commit complete.

sql>create table t2(c1 varchar2(30));

Table created.

sql>declare
2 v_sql varchar2(200);
3 v_text varchar2(100);
4 begin
5 v_sql:='select c1 from t1';
6 execute immediate v_sql into v_text;
7
8 insert into t2
9 values(v_text);
10 end;
11 /

PL/SQL procedure successfully completed.

sql>select * from t2;

C1
------------------------------
aaaabbbcccc789

ITPub博客

Convert long to char

最新文章