设为首页 加入收藏

TOP

Oracle Decode and CASE Sample
2014-11-23 21:54:25 】 浏览:5033
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自动备份

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目