This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I have an interesting problem relating to CLOB usage in an Oracle 8i table. I am writing a large string of data to this column and whenever we are writing something shorter than the original text, it doesn't overwrite the remaining existing text.
I know that the solution is to use empty_clob(), however I can't find any examples of this when using an update statement. Can anyone please help?