yc15128221056的博客

sql如下:select * from taf_install where ins_no = 'AZ0012018071100068';BEGIN TRANSACTION;--or BEGIN;开启事物DELETE from taf_install where ins_no = 'AZ0012018071100068';select * from taf_install where ins_no ...

1.相当于if__ else(if __else if __else用法) decode(value,if1,then1,if2,then2,if3,then3,...,else) select decode(1,1,100,800)from dual;--100(if_else_),如果1等于1,则100,如果1不等于1,则800 select decode(1,0,100,800) fro...