一个小应用 思路值得借鉴. decode(nvl(loan_type, 0) || nvl(acc_isbsbank, 0)||decode(nvl(ACC_HOUSESTATUSEX, 0), 15, 1,0), '300', 1, 0)