華閱文章網oracle里面如何寫case語句呢
SELECT LogID,UserID,LogTime,Url,Description,(case OperateType when OperateType = 0 then '新增' when OperateType=1 then '修改' else '刪除' end case) FROM LOG 1。
case SELECT LogID,UserID,LogTime,Url,Description,( case when OperateType = 0 then '新增' when OperateType=1 then '修改' else '刪除' end ) FROM LOG 2。 DECODE的寫法： SELECT LogID,UserID,LogTime,Url,Description, decode(OperateType,0，'新增'，1，'修改'，'刪除') OperationName。
mysql的casewhen語句轉oraclewhere子句條件如下：*='asdf'
oracle也有case when的語法，照辦就行，不過用在where條件中，需要有返回值的比較.這是根據你提供的語句修改，給你提供一個參考吧：where * = 'asdf' and (case when (b.i like '%0%') then true when (b.i like '%1%') and *rCode = #code# then truewhen (b.i like '%2%') and (*Dept = #dept# and #flag# = 1) then trueelse falseend) = true這是按照我的業務理解寫的where * = 'asdf' and (case when (b.i like '%0%') then 1when (b.i like '%1%') and *rCode = #code# then 2when (b.i like '%2%') and (*Dept = #dept# and #flag# = 1) then 3else 4end) = 1 -- （根據反回結果來過濾數據）。
Oracle中case語句的用法
select case *_place is null then ''
else *_place end
end
from a,b where *_place=*_code
可以不用Case:
Select NVL(*_Place,'') From a,b where *_place=*_code
select case *_place When null then '' else *_place end
from a,b where *_place=*_code
就這樣。
誰有oracle的case語句的例子
select student,nvl(sum(yuwen),-1) as yuwen,nvl(sum(shuxue),-1) as shuxue,nvl(sum(wuli),-1) as wuli from ( select student, case when cource='yuwen' then mark else null end as yuwen, case when cource='shuxue' then mark else null end as shuxue, case when cource='wuli' then mark else null end as wuli from bob_cj ) group by student order by student。
數據庫sql中的case語句~
set 不能連續的賦值。
case 語句也有錯誤。可以改為：declare @grade int,@result varchar(10)set @grade=78set @result= case when @grade<60 then '不及格' when @grade>=60 and @grade <69 then '及格' when @grade>=70 and @grade<79 then '中等' when @grade>=80 and @grade<89 then '良好' when @grade>=90 and @grade<=100 then '優秀' else 'wrong'endselect @result。
轉載請注明出處華閱文章網 » oracle的case語句
