Convert long to char

将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博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134943/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134943/