This topic has been archived. It cannot be replied.
-
工作学习 / IT杂谈 / 请教各位：有一个oracle表中某一列每行数据都含有回车键字符，如何替换回车键为其他字符，如空格键？谢谢！
-cloud2001(卷云溶月*冰花飞扬*);
2004-2-27
(#1622950@0)
-
在程序里面把\r\n换成' '？
-fatbean(happylife);
2004-2-27
(#1623023@0)
-
I used select replace(c1,'\n\r',' ') from t1 but didn't work.
-cloud2001(卷云溶月*冰花飞扬*);
2004-2-27
(#1623033@0)
-
40分钟内还没人回答的话我就现装一个Oracle帮你试试
-fatbean(happylife);
2004-2-27
(#1623047@0)
-
"\r\n" != "\n\r"
-canadiantire(ct);
2004-2-27
(#1623073@0)
-
try select replace(c1, chr(13)||chr(10),' ') or select replace(c1, chr(10)||chr(13),' ')
-schen(糊涂阿福);
2004-2-27
(#1623106@0)
-
It works, thanks for all your kindly help. Have a good weekend.
-cloud2001(卷云溶月*冰花飞扬*);
2004-2-27
(#1623165@0)