Oracle long转为varchar2

create table test(table_name varchar2(100));
select * from test for update;

create table test1( view_name varchar2(100),text clob)

insert into test1 select view_name,to_lob(text) from user_views;