SQL> l 1 select number_of_orders, 2 sample_no, 3 proc_type, 4 time_proc_s, 5 to_char(create_date,'DD-Mon-YYYY HH24:MI:SS') date_stamp, 6 order_sum_amount 7 from op_results 8* order by 5 SQL> / NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 100000 1 set 0.0685 24-May-2012 17:22:52 2.3399E+10 100000 2 set 0.0654 24-May-2012 17:22:56 2.3399E+10 100000 3 set 0.0648 24-May-2012 17:23:00 2.3399E+10 100000 4 set 0.0648 24-May-2012 17:23:04 2.3399E+10 100000 5 set 0.0657 24-May-2012 17:23:08 2.3399E+10 100000 6 set 0.0659 24-May-2012 17:23:12 2.3399E+10 100000 7 set 0.0652 24-May-2012 17:23:16 2.3399E+10 100000 8 set 0.0650 24-May-2012 17:23:21 2.3399E+10 100000 9 set 0.0651 24-May-2012 17:23:25 2.3399E+10 100000 10 set 0.0658 24-May-2012 17:23:29 2.3399E+10 100000 11 set 0.0651 24-May-2012 17:23:33 2.3399E+10 100000 12 set 0.0650 24-May-2012 17:23:37 2.3399E+10 100000 1 row 242.9725 24-May-2012 17:27:44 2.3399E+10 100000 2 row 243.0329 24-May-2012 17:31:51 2.3399E+10 100000 3 row 244.8478 24-May-2012 17:36:00 2.3399E+10 100000 4 row 245.5109 24-May-2012 17:40:10 2.3399E+10 100000 5 row 245.7224 24-May-2012 17:44:20 2.3399E+10 100000 6 row 244.8503 24-May-2012 17:48:29 2.3399E+10 100000 7 row 247.6264 24-May-2012 17:52:40 2.3399E+10 100000 8 row 245.6501 24-May-2012 17:56:50 2.3399E+10 100000 9 row 244.1341 24-May-2012 18:00:58 2.3399E+10 100000 10 row 245.0570 24-May-2012 18:05:07 2.3399E+10 100000 11 row 244.9006 24-May-2012 18:09:16 2.3399E+10 100000 12 row 243.6248 24-May-2012 18:13:24 2.3399E+10 200000 1 set 0.1323 24-May-2012 18:15:06 4.7070E+10 200000 2 set 0.1312 24-May-2012 18:15:11 4.7070E+10 200000 3 set 0.1308 24-May-2012 18:15:15 4.7070E+10 200000 4 set 0.1307 24-May-2012 18:15:19 4.7070E+10 200000 5 set 0.1308 24-May-2012 18:15:23 4.7070E+10 200000 6 set 0.1320 24-May-2012 18:15:27 4.7070E+10 200000 7 set 0.1309 24-May-2012 18:15:32 4.7070E+10 200000 8 set 0.1306 24-May-2012 18:15:36 4.7070E+10 200000 9 set 0.1299 24-May-2012 18:15:40 4.7070E+10 200000 10 set 0.1307 24-May-2012 18:15:44 4.7070E+10 200000 11 set 0.1324 24-May-2012 18:15:48 4.7070E+10 200000 12 set 0.1312 24-May-2012 18:15:53 4.7070E+10 200000 1 row 485.7186 24-May-2012 18:24:02 4.7070E+10 200000 2 row 489.4748 24-May-2012 18:32:16 4.7070E+10 200000 3 row 487.5352 24-May-2012 18:40:28 4.7070E+10 200000 4 row 489.0963 24-May-2012 18:48:41 4.7070E+10 200000 5 row 485.7774 24-May-2012 18:56:51 4.7070E+10 200000 6 row 491.1542 24-May-2012 19:05:06 4.7070E+10 200000 7 row 487.6317 24-May-2012 19:13:18 4.7070E+10 200000 8 row 490.9201 24-May-2012 19:21:33 4.7070E+10 200000 9 row 487.0391 24-May-2012 19:29:44 4.7070E+10 200000 10 row 488.0598 24-May-2012 19:37:56 4.7070E+10 200000 11 row 488.7091 24-May-2012 19:46:09 4.7070E+10 NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 200000 12 row 488.1104 24-May-2012 19:54:21 4.7070E+10 300000 1 set 0.2020 24-May-2012 19:56:50 7.1103E+10 300000 2 set 0.1970 24-May-2012 19:56:54 7.1103E+10 300000 3 set 0.1967 24-May-2012 19:56:58 7.1103E+10 300000 4 set 0.1963 24-May-2012 19:57:02 7.1103E+10 300000 5 set 0.1978 24-May-2012 19:57:07 7.1103E+10 300000 6 set 0.1963 24-May-2012 19:57:11 7.1103E+10 300000 7 set 0.1967 24-May-2012 19:57:15 7.1103E+10 300000 8 set 0.1966 24-May-2012 19:57:20 7.1103E+10 300000 9 set 0.1967 24-May-2012 19:57:24 7.1103E+10 300000 10 set 0.1987 24-May-2012 19:57:28 7.1103E+10 300000 11 set 0.1971 24-May-2012 19:57:32 7.1103E+10 300000 12 set 0.1973 24-May-2012 19:57:37 7.1103E+10 300000 1 row 742.7491 24-May-2012 20:10:03 7.1103E+10 300000 2 row 738.6704 24-May-2012 20:22:26 7.1103E+10 300000 3 row 744.1731 24-May-2012 20:34:55 7.1103E+10 300000 4 row 741.0336 24-May-2012 20:47:20 7.1103E+10 300000 5 row 738.8779 24-May-2012 20:59:43 7.1103E+10 300000 6 row 740.4792 24-May-2012 21:12:07 7.1103E+10 300000 7 row 739.6586 24-May-2012 21:24:31 7.1103E+10 300000 8 row 737.0205 24-May-2012 21:36:52 7.1103E+10 300000 9 row 740.3544 24-May-2012 21:49:16 7.1103E+10 300000 10 row 737.3646 24-May-2012 22:01:38 7.1103E+10 300000 11 row 745.7338 24-May-2012 22:14:08 7.1103E+10 300000 12 row 742.0203 24-May-2012 22:26:34 7.1103E+10 400000 1 set 0.2312 24-May-2012 22:29:50 9.3946E+10 400000 2 set 0.2305 24-May-2012 22:29:54 9.3946E+10 400000 3 set 0.2316 24-May-2012 22:29:59 9.3946E+10 400000 4 set 0.2327 24-May-2012 22:30:03 9.3946E+10 400000 5 set 0.2310 24-May-2012 22:30:07 9.3946E+10 400000 6 set 0.2322 24-May-2012 22:30:12 9.3946E+10 400000 7 set 0.2321 24-May-2012 22:30:16 9.3946E+10 400000 8 set 0.2322 24-May-2012 22:30:20 9.3946E+10 400000 9 set 0.2324 24-May-2012 22:30:25 9.3946E+10 400000 10 set 0.2324 24-May-2012 22:30:29 9.3946E+10 400000 11 set 0.2318 24-May-2012 22:30:33 9.3946E+10 400000 12 set 0.2315 24-May-2012 22:30:37 9.3946E+10 400000 1 row 1011.4400 24-May-2012 22:47:33 9.3946E+10 400000 2 row 1001.4106 24-May-2012 23:04:19 9.3946E+10 400000 3 row 1005.1095 24-May-2012 23:21:08 9.3946E+10 400000 4 row 997.6294 24-May-2012 23:37:49 9.3946E+10 400000 5 row 1001.2946 24-May-2012 23:54:35 9.3946E+10 400000 6 row 1002.8242 25-May-2012 00:11:22 9.3946E+10 400000 7 row 1000.6868 25-May-2012 00:28:06 9.3946E+10 400000 8 row 1001.9608 25-May-2012 00:44:53 9.3946E+10 400000 9 row 998.0636 25-May-2012 01:01:35 9.3946E+10 400000 10 row 1005.3852 25-May-2012 01:18:24 9.3946E+10 NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 400000 11 row 997.6033 25-May-2012 01:35:06 9.3946E+10 400000 12 row 1009.5434 25-May-2012 01:51:59 9.3946E+10 500000 1 set 0.3010 25-May-2012 01:56:04 1.1780E+11 500000 2 set 0.3003 25-May-2012 01:56:08 1.1780E+11 500000 3 set 0.3008 25-May-2012 01:56:12 1.1780E+11 500000 4 set 0.3013 25-May-2012 01:56:17 1.1780E+11 500000 5 set 0.3004 25-May-2012 01:56:21 1.1780E+11 500000 6 set 0.3013 25-May-2012 01:56:26 1.1780E+11 500000 7 set 0.3019 25-May-2012 01:56:30 1.1780E+11 500000 8 set 0.3016 25-May-2012 01:56:34 1.1780E+11 500000 9 set 0.3016 25-May-2012 01:56:39 1.1780E+11 500000 10 set 0.3018 25-May-2012 01:56:43 1.1780E+11 500000 11 set 0.3020 25-May-2012 01:56:47 1.1780E+11 500000 12 set 0.3031 25-May-2012 01:56:52 1.1780E+11 500000 1 row 1260.7204 25-May-2012 02:17:57 1.1780E+11 500000 2 row 1249.8683 25-May-2012 02:38:51 1.1780E+11 500000 3 row 1255.0924 25-May-2012 02:59:50 1.1780E+11 500000 4 row 1250.7583 25-May-2012 03:20:45 1.1780E+11 500000 5 row 1245.0326 25-May-2012 03:41:34 1.1780E+11 500000 6 row 1252.7073 25-May-2012 04:02:30 1.1780E+11 500000 7 row 1247.1671 25-May-2012 04:23:22 1.1780E+11 500000 8 row 1256.3645 25-May-2012 04:44:22 1.1780E+11 500000 9 row 1241.4705 25-May-2012 05:05:08 1.1780E+11 500000 10 row 1259.0367 25-May-2012 05:26:11 1.1780E+11 500000 11 row 1242.6644 25-May-2012 05:46:57 1.1780E+11 500000 12 row 1248.7788 25-May-2012 06:07:50 1.1780E+11 600000 1 set 0.3619 25-May-2012 06:12:47 1.4188E+11 600000 2 set 0.3599 25-May-2012 06:12:52 1.4188E+11 600000 3 set 0.3604 25-May-2012 06:12:56 1.4188E+11 600000 4 set 0.3612 25-May-2012 06:13:01 1.4188E+11 600000 5 set 0.3614 25-May-2012 06:13:05 1.4188E+11 600000 6 set 0.3600 25-May-2012 06:13:10 1.4188E+11 600000 7 set 0.3604 25-May-2012 06:13:14 1.4188E+11 600000 8 set 0.3595 25-May-2012 06:13:19 1.4188E+11 600000 9 set 0.3605 25-May-2012 06:13:23 1.4188E+11 600000 10 set 0.3604 25-May-2012 06:13:27 1.4188E+11 600000 11 set 0.3609 25-May-2012 06:13:32 1.4188E+11 600000 12 set 0.3625 25-May-2012 06:13:36 1.4188E+11 600000 1 row 1512.6959 25-May-2012 06:38:53 1.4188E+11 600000 2 row 1502.2439 25-May-2012 07:03:59 1.4188E+11 600000 3 row 1501.7538 25-May-2012 07:29:05 1.4188E+11 600000 4 row 1506.8854 25-May-2012 07:54:16 1.4188E+11 600000 5 row 1505.8088 25-May-2012 08:19:26 1.4188E+11 600000 6 row 1512.8095 25-May-2012 08:44:43 1.4188E+11 600000 7 row 1507.9560 25-May-2012 09:09:55 1.4188E+11 600000 8 row 1509.6910 25-May-2012 09:35:09 1.4188E+11 600000 9 row 1507.0060 25-May-2012 10:00:20 1.4188E+11 NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 600000 10 row 1510.0381 25-May-2012 10:25:34 1.4188E+11 600000 11 row 1504.3282 25-May-2012 10:50:42 1.4188E+11 600000 12 row 1504.0006 25-May-2012 11:15:50 1.4188E+11 700000 1 set 0.4288 25-May-2012 11:21:38 1.6463E+11 700000 2 set 0.4276 25-May-2012 11:21:42 1.6463E+11 700000 3 set 0.4279 25-May-2012 11:21:47 1.6463E+11 700000 4 set 0.4277 25-May-2012 11:21:51 1.6463E+11 700000 5 set 0.4285 25-May-2012 11:21:56 1.6463E+11 700000 6 set 0.4288 25-May-2012 11:22:00 1.6463E+11 700000 7 set 0.4272 25-May-2012 11:22:05 1.6463E+11 700000 8 set 0.4274 25-May-2012 11:22:09 1.6463E+11 700000 9 set 0.4279 25-May-2012 11:22:14 1.6463E+11 700000 10 set 0.4280 25-May-2012 11:22:18 1.6463E+11 700000 11 set 0.4283 25-May-2012 11:22:23 1.6463E+11 700000 12 set 0.4286 25-May-2012 11:22:27 1.6463E+11 700000 1 row 1789.7798 25-May-2012 11:52:21 1.6463E+11 700000 2 row 1795.2808 25-May-2012 12:22:20 1.6463E+11 700000 3 row 1803.6028 25-May-2012 12:52:28 1.6463E+11 700000 4 row 1780.6825 25-May-2012 13:22:13 1.6463E+11 700000 5 row 1776.0674 25-May-2012 13:51:53 1.6463E+11 700000 6 row 1798.1346 25-May-2012 14:21:55 1.6463E+11 700000 7 row 1793.9137 25-May-2012 14:51:53 1.6463E+11 700000 8 row 1779.2547 25-May-2012 15:21:37 1.6463E+11 700000 9 row 1805.8615 25-May-2012 15:51:46 1.6463E+11 700000 10 row 1793.8293 25-May-2012 16:21:44 1.6463E+11 700000 11 row 1774.5626 25-May-2012 16:51:23 1.6463E+11 700000 12 row 1781.2914 25-May-2012 17:21:08 1.6463E+11 800000 1 set 0.4921 25-May-2012 17:27:43 1.8896E+11 800000 2 set 0.4903 25-May-2012 17:27:48 1.8896E+11 800000 3 set 0.4902 25-May-2012 17:27:52 1.8896E+11 800000 4 set 0.4888 25-May-2012 17:27:57 1.8896E+11 800000 5 set 0.4887 25-May-2012 17:28:01 1.8896E+11 800000 6 set 0.4896 25-May-2012 17:28:06 1.8896E+11 800000 7 set 0.4890 25-May-2012 17:28:10 1.8896E+11 800000 8 set 0.4882 25-May-2012 17:28:15 1.8896E+11 800000 9 set 0.4895 25-May-2012 17:28:20 1.8896E+11 800000 10 set 0.4894 25-May-2012 17:28:24 1.8896E+11 800000 11 set 0.4888 25-May-2012 17:28:29 1.8896E+11 800000 12 set 0.4894 25-May-2012 17:28:33 1.8896E+11 800000 1 row 2014.8716 25-May-2012 18:02:12 1.8896E+11 800000 2 row 2033.8768 25-May-2012 18:36:10 1.8896E+11 800000 3 row 2021.6669 25-May-2012 19:09:56 1.8896E+11 800000 4 row 2017.1694 25-May-2012 19:43:37 1.8896E+11 800000 5 row 2028.2837 25-May-2012 20:17:29 1.8896E+11 800000 6 row 2047.3250 25-May-2012 20:51:41 1.8896E+11 800000 7 row 2020.4386 25-May-2012 21:25:25 1.8896E+11 800000 8 row 2027.8201 25-May-2012 21:59:17 1.8896E+11 NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 800000 9 row 2018.3187 25-May-2012 22:33:00 1.8896E+11 800000 10 row 2037.4145 25-May-2012 23:07:01 1.8896E+11 800000 11 row 2016.9985 25-May-2012 23:40:42 1.8896E+11 800000 12 row 2038.8954 26-May-2012 00:14:45 1.8896E+11 900000 1 set 0.5626 26-May-2012 00:22:03 2.1234E+11 900000 2 set 0.5616 26-May-2012 00:22:08 2.1234E+11 900000 3 set 0.5624 26-May-2012 00:22:12 2.1234E+11 900000 4 set 0.5613 26-May-2012 00:22:17 2.1234E+11 900000 5 set 0.5600 26-May-2012 00:22:22 2.1234E+11 900000 6 set 0.5593 26-May-2012 00:22:26 2.1234E+11 900000 7 set 0.5588 26-May-2012 00:22:31 2.1234E+11 900000 8 set 0.5600 26-May-2012 00:22:36 2.1234E+11 900000 9 set 0.5604 26-May-2012 00:22:40 2.1234E+11 900000 10 set 0.5594 26-May-2012 00:22:45 2.1234E+11 900000 11 set 0.5614 26-May-2012 00:22:50 2.1234E+11 900000 12 set 0.5599 26-May-2012 00:22:54 2.1234E+11 900000 1 row 2368.4242 26-May-2012 01:02:27 2.1234E+11 900000 2 row 2325.2362 26-May-2012 01:41:16 2.1234E+11 900000 3 row 2343.3313 26-May-2012 02:20:23 2.1234E+11 900000 4 row 2321.3087 26-May-2012 02:59:09 2.1234E+11 900000 5 row 2339.3879 26-May-2012 03:38:12 2.1234E+11 900000 6 row 2332.4795 26-May-2012 04:17:09 2.1234E+11 900000 7 row 2344.5607 26-May-2012 04:56:17 2.1234E+11 900000 8 row 2327.1219 26-May-2012 05:35:09 2.1234E+11 900000 9 row 2330.8941 26-May-2012 06:14:04 2.1234E+11 900000 10 row 2344.6560 26-May-2012 06:53:12 2.1234E+11 900000 11 row 2314.4806 26-May-2012 07:31:51 2.1234E+11 900000 12 row 2377.8653 26-May-2012 08:11:33 2.1234E+11 1000000 1 set 0.6291 26-May-2012 08:19:36 2.3588E+11 1000000 2 set 0.6281 26-May-2012 08:19:41 2.3588E+11 1000000 3 set 0.6271 26-May-2012 08:19:45 2.3588E+11 1000000 4 set 0.6283 26-May-2012 08:19:50 2.3588E+11 1000000 5 set 0.6280 26-May-2012 08:19:55 2.3588E+11 1000000 6 set 0.6293 26-May-2012 08:20:00 2.3588E+11 1000000 7 set 0.6289 26-May-2012 08:20:04 2.3588E+11 1000000 8 set 0.6285 26-May-2012 08:20:09 2.3588E+11 1000000 9 set 0.6285 26-May-2012 08:20:14 2.3588E+11 1000000 10 set 0.6299 26-May-2012 08:20:18 2.3588E+11 1000000 11 set 0.6286 26-May-2012 08:20:23 2.3588E+11 1000000 12 set 0.6280 26-May-2012 08:20:28 2.3588E+11 1000000 1 row 2541.4223 26-May-2012 09:02:53 2.3588E+11 1000000 2 row 2532.9815 26-May-2012 09:45:10 2.3588E+11 1000000 3 row 2559.4504 26-May-2012 10:27:54 2.3588E+11 1000000 4 row 2550.0295 26-May-2012 11:10:28 2.3588E+11 1000000 5 row 2528.7114 26-May-2012 11:52:41 2.3588E+11 1000000 6 row 2553.7939 26-May-2012 12:35:19 2.3588E+11 1000000 7 row 2566.8463 26-May-2012 13:18:10 2.3588E+11 NUMBER_OF_ORDERS SAMPLE_NO PROC_ TIME_PROC_S DATE_STAMP ORDER_SUM_AMOUNT ---------------- ---------- ----- ------------ ----------------------------- ---------------- 1000000 8 row 2537.8883 26-May-2012 14:00:32 2.3588E+11 1000000 9 row 2578.2585 26-May-2012 14:43:34 2.3588E+11 1000000 10 row 2524.0053 26-May-2012 15:25:42 2.3588E+11 1000000 11 row 2543.0543 26-May-2012 16:08:09 2.3588E+11 1000000 12 row 2570.6456 26-May-2012 16:51:04 2.3588E+11 240 rows selected.