10g - Column Conversion: Varchar2 to CLOB

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



.

Relevant Pages

  • Re: 10g - Column Conversion: Varchar2 to CLOB
    ... 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? ...
    (comp.databases.oracle.server)
  • Re: Northwind
    ... sales invoice, which tracks each individual ... Unique employees - can they belong to more ... employees, boards, tasks and skills perhaps, etc. ... >> You should also have a worker table with all the worker ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Graduates sing the blues
    ... >>>communicating but locals know how to communiate better because they ... >> employees is ... >> their inability to communicate properly - lack of language skills as well ... Now they churn out graduates ...
    (soc.culture.malaysia)
  • Re: advice on books to learn cobol
    ... IT in particular) expect their employees to do a lot by learning things ... If I tell them that resources are needed they will instantly remove me ... They should decide if they are serious about doing this before proceeding. ... quickly as possible new skills required for tasks in company without ...
    (comp.lang.cobol)
  • Re: H1-B with GEMS
    ... you have suitable matching for the below mentioned skills who are ... Primarily SAP, Peoplesoft,Java developer/architect, Oracle ... Business Analysis or other technologies. ... Our employees work in several skills including Web Technologies, ...
    (comp.software.testing)