设为首页 加入收藏

TOP

Oracle Decode and CASE Sample
2014-11-23 21:54:25 来源: 作者: 【 】 浏览:9
Tags:Oracle Decode and CASE Sample

create table testabc(
a Number,
b Date
);

insert into testabc(a,b) values(1, TO_DATE(1-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));
insert into testabc(a,b) values(1, TO_DATE(2-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));
insert into testabc(a,b) values(1, TO_DATE(3-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));
insert into testabc(a,b) values(1, TO_DATE(4-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));
insert into testabc(a,b) values(1, TO_DATE(5-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));
insert into testabc(a,b) values(1, TO_DATE(6-MAY-2010/00:00, DD-MON-YYYY/HH24:MI));

select a,b,decode(sign(b - TO_DATE(3-MAY-2010/00:00, DD-MON-YYYY/HH24:MI)), -1, his, 1, cur, his) as type from testabc;
select a,b,case when b <= TO_DATE(3-MAY-2010/00:00, DD-MON-YYYY/HH24:MI) then his else cur end type from testabc;

drop table testabc;

In theory, case when will have a better performance.

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Sqlplus与oracle连接问题汇总 下一篇oracle自动备份

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: