oracle8.1.6 select to_char(timestamp,'YYYY-MM-DD HH24:MI:SS') as timestamp, result, notes from aa_test_results where testcase_id = :testcase_id and package_key = :package_key $filter order by test_id select fails from aa_test_final_results where testcase_id = :testcase_id