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!

Regular Expression. Select Statement. Carriage Return

432921Jun 1 2005 — edited Jun 2 2005

Oracle 9i
Using SQLPLUS

I've read about regular expression and need some translation/explanation.

I have a large table containing a varchar2 (free text) column. Users may have inserted carriage returns when they entered the data. I need to locate rows that contain carriage returns, select and display them. Later I'll need to update those rows to replace the carriage returns with a space.

Can you assist with syntax. I believe use of a regular expression is required.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2005

Added on Jun 1 2005

4 comments

636 views