Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SQL Query - HELP!!!
I need to replace the underscore '_' character in my database with
either dashes '-' or obliques '/', depending on each case.
In order to determine which numbers get which replacement character, I
need to find all occurances of numbers containing the underscore '_'
character.
Every time I write a script, I get stumped 'cause underscore '_' is a
reserved character meaning "one character"...
How do I either declare underscore '_' as a value or is there an
"escape" as in old DB2 that will let me redefine the character for the
purposes of this one script??
Thanks all for great help!
8 out
Received on Fri May 11 2001 - 10:01:28 CDT