Oracle - Convert varchar2 to Clob datatype

In order to convert a column datatype from varchar2 to clob do:

step 1 - add a column with clob datatype:

alter table add( clob);


step 2 - copy data from the source column to the new one:

update set = ;


step 3 - rename the new column created in the step 1 in order to complete the process:

alter table
rename column
to ;
alter table
rename column
to ;

Comments

Popular posts from this blog

Hibernate - HibernateException: createQuery is not valid without active transaction