oracle decode 在access中有别的函数能代替吗?答:有, IIf IIf (a=b, c, d) 相当于 If a=b then c else d 例如 Oracle:SELECT supplier_name,decode(supplier_id,10000, 'IBM',10001, 'Microsoft',10002, 'HP','Gateway') result FROM suppliers;Access:SELECT supplier_name,IIf (supplier_id = 10000, 'IBM',IIf (supplier_id =...