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
bkpepala
Messages: 1
Registered: January 2009
Junior Member
hi,

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.

thanks,
Bharath
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: 64119
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.

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


Current Time: Tue Dec 06 10:21:47 CST 2016

Total time taken to generate the page: 0.08696 seconds