1.1.1 Decode
decode(V1,1,A,2,B,C):如果V1=1,返回A;等于2返回B;等于其它值返回C。
selectdecode(2,1,'t',2,'f',5) from dual; f
1.1.1 Nvl
Nvl(A,1) 如果A字段为空,则显示1
selectnvl('',1) from dual; 1
selectnvl('2',1) from dual; 2
selectnvl(' ',1) from dual; 空
selectnvl(null,1) from dual; 1
1.1.1 Case when……then……end
selectcasewhen3=1then'F1'
when3=2then'F'
when3=3then'T'
end
from dual; --T
decode(V1,1,A,2,B,C):如果V1=1,返回A;等于2返回B;等于其它值返回C。
selectdecode(2,1,'t',2,'f',5) from dual; f
1.1.1 Nvl
Nvl(A,1) 如果A字段为空,则显示1
selectnvl('',1) from dual; 1
selectnvl('2',1) from dual; 2
selectnvl(' ',1) from dual; 空
selectnvl(null,1) from dual; 1
1.1.1 Case when……then……end
selectcasewhen3=1then'F1'
when3=2then'F'
when3=3then'T'
end
from dual; --T