case

SELECT X.RES_NO, (NM_1||'|'||NM_2||'|'||NM_3||'|'||NM_4||'|'||NM_5||'|'||NM_6||'|'||NM_7||'|'||NM_8||'|'||NM_9||'|'||NM_10) AS ALL_NM FROM ( SELECT RES_NO , MAX(CASE SEQ WHEN 1 THEN B.DELI_KR_NM END) NM_1 , MAX(CASE SEQ WHEN 2 THEN B.DELI_KR_NM END) NM_2 , MAX(CASE SEQ WHEN 3 THEN B.DELI_KR_NM END) NM_3 , MAX(CASE SEQ WHEN 4 THEN B.DELI_KR_NM END) NM_4 , MAX(CASE SEQ WHEN 5 THEN B.DELI_KR_NM END..

CASE SELECT deptno , CASE deptno WHEN 1 THEN 'ONE' WHEN 2 THEN 'TOW' ELSE 'OTHER' END as "DEPT NAME" FROM emp; DECODE SELECT deptno, DECODE(deptno,'1','ONE','2','TWO') as "DEPT NAME" FROM emp;