Order by 的数值型灵活使用
代码:
select * from table_a where id=p_id order by decode(函数,'asc',1,'desc',-1)*jsny;
控制试图的访问时间：
6. 代码:
create view ...
as
select ... from where exists(select x from dual where sysdate=8:00am and sysdate=5:00pm)
妙用decode实现排序
代码:
select * from tabname
order by decode(mode,'FIFO',1,-1)*to_char(rq,'yyyymmddhh24miss');
select * from tabname
order by decode(mode,'FIFO',rq-sysdate, sysdate-rq)
找出某个时期内工作日数：
代码: ...[ 查看全文 ]
