Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: CONCAT Long and String
DA Morgan wrote:
> Andreas Schlegel wrote:
>>I need to update a LONG col. I tried it in this way: >>UPDATE comp SET field1=CONCAT(field1, 'additional remark') WHERE ckey=4711; >> >>But that construct throws the error ORA-00932. I tried some cast >>functions but they won't work.
... but as you
> didn't ... go to http://tahiti.oracle.com and look up LONG data type. You'll
> not be doing this in SQL.
>
> And it would be best to migrate to CLOB datatype.
... and then - how do I cast from a String to CLOB?
Thanks for your help.
![]() |
![]() |