sql语言艺术（2）简洁的SQL

 

select closure_date bulk collect into dtPerStaArray form tperrslt where fiscal_year=to_char(Param_dtAcc,'YYYY') and rslt_period in('1' || to_char(Param_dtAcc,'MM'), '9' || to_char(Param_dtAcc,'MM') ) order by rslt_period;