Oracle数据库中下拉列表动态添加年份SQL语句

来源:互联网 发布:刺客信条起源优化补丁 编辑:程序博客网 时间:2024/05/29 03:02
select to_char(sysdate,'yyyy')-5 itemvalue from dual
union
select to_char(sysdate,'yyyy')-4 itemvalue from dual
union
select to_char(sysdate,'yyyy')-3 itemvalue from dual
union
select to_char(sysdate,'yyyy')-2 itemvalue from dual
union
select to_char(sysdate,'yyyy')-1 itemvalue from dual
union
select to_char(sysdate,'yyyy')+0 itemvalue from dual
union
select to_char(sysdate,'yyyy')+1 itemvalue from dual
union
select to_char(sysdate,'yyyy')+2 itemvalue from dual
union
select to_char(sysdate,'yyyy')+3 itemvalue from dual
union
select to_char(sysdate,'yyyy')+4 itemvalue from dual
union
select to_char(sysdate,'yyyy')+5 itemvalue from dual
原创粉丝点击