Oracle case when decode and sequence

发布时间：2020-12-12 14:34:34 所属栏目：百科来源：网络整理

导读：select grade,decode(grade,1,'a',2,'b','c') from salgrade;select grade,case when grade=1 then 'a' when grade=2 then 'b' else 'c' end from salgrade; create sequence empno_seqmaxvalue 99999start with 15increment by 1;select empno_seq.nextval

select grade,decode(grade,1,'a',2,'b','c') from salgrade;
select grade,case when grade=1 then 'a' when grade=2 then 'b' else 'c' end from salgrade;

create sequence empno_seq
maxvalue 99999
start with 15
increment by 1
;

select empno_seq.nextval from dual;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!