摘要:
1、decode(value,if1,then1,if2,then2,if3,then3,...,else) select DECODE(3,1,'case1',2,'case2',3,'case3',4,'case4',5,'case5',null) as testDecode from dual 阅读全文
摘要:
--复制表结构但不复制表数据create table copytest as select * from t_employee WHERE 1<>1; SELECT * FROM copytest;--复制表结构的同时复制数据create table copytest2 as SELECT * FR 阅读全文
摘要:
1、返回两个数中较大者 create or replace function chooseMax(v1 in number,v2 in number) return numberis v_max number;begin if(sign(v1-v2)>=0) then v_max:=v1; elsi 阅读全文