在项目开发中,有个需求是mini-combobox的下拉框显示学年,是个固定的范围:2000-2099学年,原来的做法是直接调用字典,传值,现在就需要自己写一段SQL来实现,给下拉框一个url让自动加载:
主要写一个这段SQL:
with t as
(select rownum rn from dual connect by rownum<=3000 )
select * from t where rn between 2000 and 2099
在项目开发中,有个需求是mini-combobox的下拉框显示学年,是个固定的范围:2000-2099学年,原来的做法是直接调用字典,传值,现在就需要自己写一段SQL来实现,给下拉框一个url让自动加载:
主要写一个这段SQL:
with t as
(select rownum rn from dual connect by rownum<=3000 )
select * from t where rn between 2000 and 2099