SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace all TAB and ENTER characters in a column

475068Mar 9 2006 — edited Mar 9 2006

Hi,

how can I replace all chr(9) & chr(12) characters in a column?

The following SQL replaces on one occurrence of TAB & ENTER, but my column can have many TAB & ENTER characters.

select trim(replace(replace(column1,chr(9),''), chr(13), '') from some_table;

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2006

Added on Mar 9 2006

3 comments

4,625 views