Home » RDBMS Server » Server Administration » Blank line.
Blank line. [message #369920] Tue, 07 November 2000 10:28
Luis Gabriel
Messages: 11
Registered: October 2000
Junior Member
Hi,

Does somebody know how can I find a control character into a field?

In a table I have a field varchar2(2000), into this field someone inserts a blank line, how can I detect or erase this??

If I unload data from the table there is a ^M in this field.

thanks

Report message to a moderator

Previous Topic: UTL_FILE reading from file (Rec Lenght>1k)
Next Topic: Sending e-mail from Oracle 8.0.5
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 23:01:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.