Source: 9cbs -
Technology community -
Oracle foundation and management issues
as follows:
Select LogID, Userid, Logtime, URL, Description, (Case OperateType when OperateType = 0 THEN 'new' When OperateType = 1 TEN 'Modify' Else 'Delete' end case from log? ? ? ?
Case
Select Logid, Userid, Logtime, URL, Description,
Case
when operatetype = 0
Then 'new
when operatetype = 1
Then 'modification'
Else 'Delete'
End) from log
2.Decode's Writing:
Select Logid, Userid, Logtime, URL, Description,
Decode (OperateType, 0, 'New', 1, 'Modify', 'Delete') Operationname
From log
Recommendation with Decode
