On Wed, 21 Mar 2001, Shakeel Qureshi wrote:
Hi Jared,
Its Oracle 8i and just need to do this operation on
a small table, using SQL and PL/SQL.
I would appreciate if you could guide me
a. As to how to find out the special characters
b. Change values
Looking forward to your help.
If you know the character you are looking for, you can paste it into
a script like the one below, to quickly fix specific tables and columns.
update table
set column_name= replace(column_name,'',null)
where column_name like '%%'
/
You can use ' ' in place of null if you really want a blank in
First off, do you have Perl and DBD::Oracle or
Java?
Those would be the preferred methods to do something
like this, in this order. PL/SQL sould be a distant
third place as it is not very fast for this kind of
wholesale string operation.
PL/SQL may be a good choice though, if your requirements