oracle8.1.6 select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year, dotlrn_terms.term_id from dotlrn_terms where dotlrn_terms.end_date > (sysdate - 360) and dotlrn_terms.start_date < (sysdate + 360) order by dotlrn_terms.start_date, dotlrn_terms.end_date