Home » SQL & PL/SQL » SQL & PL/SQL » Updating a clob
Updating a clob [message #21579] Thu, 15 August 2002 11:19 Go to next message
J Wohleber
Messages: 1
Registered: August 2002
Junior Member
I need to trim a few characters from the beginning of a clob field. In MSSQL, I can do this by replacing these characters with an empty string (''). However, Oracle's DBMS_LOB.update function insists that the raw data used to replace characters be the same length as the character string being replaced.

Is there a way to alter the clob locater so that it points to different offset, and thereby it effectively trims off these unwanted characters?

Report message to a moderator

Re: Updating a clob [message #21601 is a reply to message #21579] Fri, 16 August 2002 06:31 Go to previous message
TrippersFan
Messages: 1
Registered: August 2002
Junior Member
I really don't know the answer to your question. I just wanted to say hello and that THE TRIPPERS ROCK!

Report message to a moderator

Previous Topic: Help with retrieving a recordset
Next Topic: oracle keywords
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:10:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.