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: 65153
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: LAG Function Logic
Next Topic: ORA-12052 fast refresh materialized view, complete works
Goto Forum:

Current Time: Tue Aug 22 08:13:19 CDT 2017

Total time taken to generate the page: 0.04329 seconds