Return value if exists in table 2

[adonis547]

Hello,

I've got the following table:

COMP_ID COMP_NAME COMP_PSEUDO
----------------------------------
1 ABC XXYXX
2 ORACLE YYXXY
3 DELL OOSSX
4 IBM
5 MS

So, (ABC,DELL & ORACLE) all subscribe to my fine Pseudo service, that enables them to be "cloaked" on my site. Meaning, instead of parsing DELL on my site, it'll say OOSSX.

IBM & MS will remain visible.

My question goes like this, is there a way (by fx. a trigger or something else) to return the COMP_PSEUDO field as COMP_NAME ?

Like this:
SELECT COMP_NAME FROM MY_TABLE;
-----------------
XXYXX
YYXXY
YYXXY
IBM
MS
-----------------

Any help much appreciated, thanks !

 

[datamart]

I presume you want the results as
XXYXX
YYXXY
OOSSX -- and not YYXXY, guess it was a typo.
IBM
MS

The following sql will give you comp_pseudo always if some value exists. Else.. it will return the name

SELECT DECODE(COMP_PSEUDO,NULL,COMP_NAME,COMP_PSEUDO) FROM MY_TABLE;

 

[BJCooperIT]

Another method would be:

select nvl(COMP_PSEUDO,COMP_NAME) from MY_TABLE;

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[adonis547]

Excellent - thanks to both of you.