pl/sql中怎们把vchar(4000)的数据导入到long？(感谢！)
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