update table1 set daynum = decode(floor(outtime - intime),0,1,floor(outtime - intime)) where daynum < 005748230;此SQL的含義是什么呢,decode和floor函數(shù)都明白,放在一起有點(diǎn)糊涂
關(guān)于Oracle中decode和floor的嵌套函數(shù)的講解?
慕運(yùn)維8079593
2018-07-11 14:09:23