pl/sql中，怎么把table1中列a类型vchar(4000)的数据，（里面的存放是sql语句）导入到列b类型 long类型的列？
还是列b必须为大对象才可以？新手，详细些！感谢！
另，能给个学习pl/sql 和oracle的好书的连接么？多谢！
------解决方案--------------------
奇怪：
SQL> create table tbl1(cname varchar(4000));
Table created
Executed in 0.141 seconds
SQL> insert into tbl1 select 'asdasdasdadsasdadadada ' from dual;
1 row inserted
Executed in 0.016 seconds
SQL> create table tbl2(cname long);
Table created
Executed in 0 seconds
SQL> insert into tbl2 select cname from tbl1;
1 row inserted
Executed in 0 seconds
SQL> select * from tbl2;
CNAME
--------------------------------------------
asdasdasdadsasdadadada
Executed in 0.015 seconds