oracle8.1.7 select to_char(timestamp,'DD/MM/YYYY HH:MI:SS') timestamp, result, notes from aa_test_results where testcase_id = :testcase_id and package_key = :package_key order by test_id select fails from aa_test_final_results where testcase_id = :testcase_id