请参考:select * from( with T_CUST as ( select 1 CUST_NO, '1' CUST_TYPE from dual union all select 2,'A' from dual union all select 3,'M' from dual union all select 4,'C' from dual union all select 5,'A' from dual union all select 6,'M' from dual union all select 7,'3' from dual ) SELECT DECODE(CUST_TYPE, 'A', 'HP', '1', 'HP', 'C', 'DELL', '3', 'DELL', 'IBM') AS NAME from T_CUST )
with T_CUST as
(
select 1 CUST_NO, '1' CUST_TYPE from dual
union all
select 2,'A' from dual
union all
select 3,'M' from dual
union all
select 4,'C' from dual
union all
select 5,'A' from dual
union all
select 6,'M' from dual
union all
select 7,'3' from dual
)
SELECT DECODE(CUST_TYPE, 'A', 'HP', '1', 'HP', 'C', 'DELL', '3', 'DELL', 'IBM')
AS NAME
from T_CUST
)