THANX a lot to all who replied !!!
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 05, 2001 7:32 PM
To: Multiple recipients of list ORACLE-L
You guys are all doing this the hard way!
Regular expressions to the rescue!
Andrey,
how about the function below. you can change the SUBSTR commands below to
tailor to your use.
To use the function, you can :
update {table}
set column_name = wtw_name_fix(column_name);
hope this helps.
CREATE OR REPLACE FUNCTION WTWDBA.Wtw_Name_Fix(in_string IN VARCHAR2)
Many thanks to all who replied !!!
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 05, 2001 3:20 PM
To: [EMAIL PROTECTED]
Hi,
An example to remove the spaces using the translate function is as follows.
create table test
Now HERE is something to research..
thanks Jared!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, September 05, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L
You guys are all doing this the hard way!
Regular expressions to the rescue!
You guys are all doing this the hard way!
Regular expressions to the rescue!
Here's a complete test:
declare
tstr varchar2(100) := 'this contains tabsmultiple spaces and
single spaces';
begin
dbms_output.put_line( tstr);
owa_pattern.change( tstr, '\s', '', 'g');