OraFAQ Forum: SQL & PL/SQL » "null" in between fields

Home » SQL & PL/SQL » SQL & PL/SQL » "null" in between fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"null" in between fields [message #6790]

Tue, 06 May 2003 09:57

yen chew
Messages: 6
Registered: May 2001

Junior Member

I have 2 tables. One with good entry and one where there is a "null" or "space" between the text.
This has somehow caused the database not to recognized the field. Example: email address in table a: 'oracle1@oracle.com'
and email address in table b: 'oracle1 @oracle.com'.

How do I get table a to recognized table b's email address?

Report message to a moderator

Re: "null" in between fields [message #6791 is a reply to message #6790]

Tue, 06 May 2003 10:10

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

I'm assuming that's a space in the "bad" E-mail address...?

Shouldn't you clean the data first, then do your compare?

UPDATE b
SET    b.email_address = REPLACE(b.email_address,' ');

If this path is not feasible for you, then just

SELECT ...
FROM   a
,      b
WHERE  a.email_address = <a href="http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions102a.htm#78610">REPLACE</a>(b.email_address,' ');

Good luck,

A

Report message to a moderator

Previous Topic:	calling sql from stored procedure
Next Topic:	Create Rule

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 28 01:29:35 CST 2025