大侠们:
请看这个表
table p
period_type from_date end_date
weekdays 1 3
weekdays 5 5
weekend 6 7
要实现:
period_type w_date
weekdays 1
weekdays 2
weekdays 3
weekdays 5
weekend 6
weeeend 7
请问大虾能否用sql 来实现,兄弟多谢了!
请看这个表
table p
period_type from_date end_date
weekdays 1 3
weekdays 5 5
weekend 6 7
要实现:
period_type w_date
weekdays 1
weekdays 2
weekdays 3
weekdays 5
weekend 6
weeeend 7
请问大虾能否用sql 来实现,兄弟多谢了!
( select decode(period_type,'weekdays',0,1) type,period_type,from_date w_date
from p
uion all
select decode(period_type,'weekdays',0,1) type,period_type,end_date
from p
) a
order by a.type
from p, (select rownum no from all_objects where rownum < 8) a
where a.no between p.from_date and p.end_date
order by p.period_type, a.no