[snip]
I need to run an extract of some data from our Oracle DB's. One of the
restrictions is that I need to write a SQL script that will parse through a
particular field for a "/"
and if found, I have to remove it and output the data without the slash.
I have minor experience with selecting data that I need based on a where
clause and spooling the info to a file. But I haven't had any experience
parsing through a field for invalid characters.
Any ideas on how I should approach this?
[/snip]
Since it is Oracle I cannot be sure as it has been a long time since I did
PL/SQL, but I think you have a substr (sub-string) function available that
will allow you to search for that which you are looking for. MySQL has
REPLACE...
SELECT REPLACE("this/sentence", "/", " ")
out put is "this sentence"
HTH!
Jay
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
