Re: 10g - Column Conversion: Varchar2 to CLOB

Craig wrote:
> 10g:
>
> Say I have EMPLOYEES table with column Skills as varchar2
> I need to convert Skills to NCLOB, this is the "right way" to do it ?
>
> alter table EMPLOYEES add skills_clob nclob ;
> update EMPLOYEES set skills_clob = skills ;
> commit;
>
> alter table EMPLOYEES drop column skills;
> alter table EMPLOYEES rename column skills_clob to skills;
>
>
>
> thanks

http://www.psoug.org/reference/builtin_functions.html and search for NCLOB.

May help depending on precisely what you are doing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org