Oracle uses chr(13) to denote an 0D and chr(10) to denote an 0A. If you need to add or remove these from a column you can use these values in your query. I needed to remove them from a notes field so I used the following
replace(column,chr(10)) - this removed all 0As from the column.
Wednesday, April 30, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment