SELECT ADD_MONTHS(A.YEAR_START,3 * RN) - 1 END_DATE, A.YEAR_START FROM JAI_FA_AST_YEARS A, (SELECT ROWNUM RN FROM ALL_OBJECTS WHERE ROWNUM <= 4) B ORDER BY A.YEAR_START, A.YEAR_END
View Text - HTML Formatted
SELECT ADD_MONTHS(A.YEAR_START , 3 * RN) - 1 END_DATE , A.YEAR_START FROM JAI_FA_AST_YEARS A , (SELECT ROWNUM RN FROM ALL_OBJECTS WHERE ROWNUM <= 4) B ORDER BY A.YEAR_START , A.YEAR_END