Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Renaming column of CLOBs

Renaming column of CLOBs

From: Bruce C. Miller <bm3719_at_gmail.com>
Date: 8 Jun 2006 10:27:43 -0700
Message-ID: <1149787663.604048.273940@j55g2000cwa.googlegroups.com> 





I have a table with a column of CLOBs that I want to rename. I can
create the new column of CLOB type, but doing an UPDATE and SET on the
new and old columns doesn't copy the data over properly. I guess I need
to use the DBMS_LOB.COPY function, but I am not sure how to use this on
a full column of data.



Seems like a simple problem, but I haven't been able to find the answer
online yet.
Received on Thu Jun 08 2006 - 12:27:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US