select *
from TL_PRODUCTSTOCKPILEN t
where decode(t.i_ldgmonth,
'1',
'01',
'2',
'02',
'3',
'03',
'4',
'04',
'5',
'05',
'6',
'06',
'7',
'07',
'8',
'08',
'9',
'09',
t.i_ldgmonth) = '07'
and t.C_ID not in (select distinct C_ID from TL_TEMPSTOCKPILEN)
含义解释:
decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)
该函数的含义如下:
IF 条件=值1 THEN
RETURN(翻译值1)
ELSIF 条件=值2 THEN
RETURN(翻译值2)
......
ELSIF 条件=值n THEN
RETURN(翻译值n)
ELSE
RETURN(缺省值)
END IF