Http://doc.linuxpk.com/49161.html
As follows:
SELECT logid,userid,logtime,url,description, (case operatetype when operatetype = 0 Then ' Add ' when operatetype=1 then ' modify ' Else ' delete ' end case ' from LOG
1. Case
SELECT Logid,userid,logtime,url,description, (
Case
When operatetype = 0
Then ' Add '
When operatetype=1
Then ' modify '
Else ' delete '
End) from LOG
2.DECODE of the wording:
SELECT Logid,userid,logtime,url,description,
Decode (operatetype,0, ' Add ', 1, ' modify ', ' delete ') OperationName
From LOG
Suggested to use decode
How to use Oracle's decode function to do multivalued judgment
The syntax structure of the DECODE function is as follows:
Decode (expression, search_1, result_1) decode (
expression, search_1, Result_1, search_2, result_2)
decode ( Expression, search_1, Result_1, search_2, Result_2, ..., Search_n, result_n)
decode (expression, search_1, result_1 , default)
decode (expression, search_1, Result_1, search_2, result_2, default)
decode (expression, search_1, Result_1, search_2, Result_2, ..., search_n, result_n, default)
|
The decode function compares expressions and search words, returns the result if it matches, returns a default value if it does not match, and returns a null value if no default value is defined.