Oracle get the maximum date

Oracle obtains the maximum DATE SQL code www.2cto.com -- Created on 2010/06/08 by NAN declare -- Local variables here TYPE t_test IS TABLE OF DATE INDEX BY BINARY_INTEGER; v_test t_test; v_date DATE; BEGIN -- Test statements here v_test (1): = '000000'; v_test (2): = '000000'; v_test (3): = '000000 '; FOR I IN 1 .. v_test.count loop if v_date is null then v_date: = v_test (1); end if; IF v_date <v_test (I) THEN v_date: = v_test (I); END IF; END LOOP; dbms_output.put_line (v_date); exception when others then dbms_output.put_line (Sqlerrm); end;