SELECT * FROM table (phase (t.v, 'mike')) AS d ; SELECT * FROM udftrace ORDER BY 1,2;
Result:
*** Query completed. 10 rows found. 2 columns returned. *** Total elapsed time was 1 second. o1 o2 ----------- ----------------------------------------------------- 5 mike 9 mike 7 mike 6 mike 3 mike 10 mike 1 mike 4 mike 8 mike 2 mike *** Query completed. 52 rows found. 3 columns returned. Amp_number Sequence Message ---------- ----------- ------------------------------------------ 0000 1 In Pre Init 0000 2 In Init 0000 3 In Build, input 1 is 5 0000 4 In Build setting EOF, input 1 is 5 0000 5 In Fini 0000 6 In Init 0000 7 In Build, input 1 is 1 0000 8 In Build setting EOF, input 1 is 1 0000 9 In Fini 0000 10 In Init 0000 11 In Build, input 1 is 8 0000 12 In Build setting EOF, input 1 is 8 0000 13 In Fini 0000 14 In Init 0000 15 In Build, input 1 is 2 0000 16 In Build setting EOF, input 1 is 2 0000 17 In Fini 0000 18 In END 0100 1 In Pre Init 0100 2 In Init 0100 3 In Build, input 1 is 9 0100 4 In Build setting EOF, input 1 is 9 0100 5 In Fini 0100 6 In END 0200 1 In Pre Init 0200 2 In Init 0200 3 In Build, input 1 is 7 0200 4 In Build setting EOF, input 1 is 7 0200 5 In Fini 0200 6 In Init 0200 7 In Build, input 1 is 4 0200 8 In Build setting EOF, input 1 is 4 0200 9 In Fini 0200 10 In END 0500 1 In Pre Init 0500 2 In Init 0500 3 In Build, input 1 is 6 0500 4 In Build setting EOF, input 1 is 6 0500 5 In Fini 0500 6 In END 0600 1 In Pre Init 0600 2 In Init 0600 3 In Build, input 1 is 3 0600 4 In Build setting EOF, input 1 is 3 0600 5 In Fini 0600 6 In END 0700 1 In Pre Init 0700 2 In Init 0700 3 In Build, input 1 is 10 0700 4 In Build setting EOF, input 1 is 10 0700 5 In Fini 0700 6 In END