How to take "Enter" out [message #39962] |
Wed, 28 August 2002 08:46 |
Daniel Tsai
Messages: 8 Registered: November 2001
|
Junior Member |
|
|
table: Product_ms
column:
product_id varchar2(10),
product_name varchar2(20),
product_desc varchar2(255)
When inserting into product_ms.product_desc, users pressed "enter" button in every record. As a result, ' ', HEX: 0D0A in every record. How to write a procedure to take all of them out?
Regards,
Daniel
|
|
|
|
Re: Not Working [message #39965 is a reply to message #39964] |
Wed, 28 August 2002 10:28 |
Daniel Tsai
Messages: 8 Registered: November 2001
|
Junior Member |
|
|
Thank you Todd!! But it is not working!!
I inserted one row:
INSERT INTO PRODUCT_MS
VALUES('P0001','PN115','P4 1.8GB
80HDD
CD-RW/DVD
256 MEM')
Then used the updated SQL you provided:
update product_ms set product_desc = replace(product_desc, chr(13) || chr(10));
Then nothing changed!!
Regards,
Daniel
|
|
|