Home » SQL & PL/SQL » SQL & PL/SQL » translate data trunction problem (oracle 10g,unix)
translate data trunction problem [message #385707] Tue, 10 February 2009 13:10 Go to next message
Messages: 1
Registered: January 2009
Junior Member

I am using translate in select query to translate some special characters in the clob data.but it is truncating data.

Can you suggest me how can I avoid that data truncation issue with translate.

Re: translate data trunction problem [message #385708 is a reply to message #385707] Tue, 10 February 2009 13:27 Go to previous message
Michel Cadot
Messages: 64718
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you have and you did.
Also post your Oracle version with 4 decimals.

Please read OraFAQ Forum Guide.

Previous Topic: PLS-00049: Error
Next Topic: Update Table with Primary Key Constraint
Goto Forum:

Current Time: Mon Apr 24 12:05:43 CDT 2017

Total time taken to generate the page: 0.13199 seconds