LONG类型到VARCHAR2类型会进行隐式转换,不需要函数,如:
SQL> create table t_long(col1 long);Table created.SQL> insert into t_long values ('1234');1 row created.SQL> insert into t_long values ('abc');1 row created.SQL> select * from t_long;COL1
--------------------------------------------------------------------1234
abc
SQL> create table t_long(col1 long);Table created.SQL> insert into t_long values ('1234');1 row created.SQL> insert into t_long values ('abc');1 row created.SQL> select * from t_long;COL1
--------------------------------------------------------------------1234
abc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货