order by datetime, col2 but the result is only ordered by datetime and col2's order gets messed up. Col 2 contains a string like '220.127.116.11.1'. There's only 8 strings like these so I was hoping to get the result so that the datetime is in asc order for 18.104.22.168.1 and then in ascending order for 22.214.171.124.2 and then in ascending order for 126.96.36.199.3. and so on.
I'd say that these values are sorted; however, you might not be satisfied with it. Problem is probably in a fact that numbers represented with a string are sorted differently than just numbers. Here's an example:
SQL> with test as
2 (select '1.2.3' col from dual
4 select '2.1.1' from dual
6 select '12.1.1' from dual
8 select col
9 from test
10 order by col;
Although it is "obvious" that numbers are sorted as "1, 2, 12", string sort puts "12" in front of "2". Therefore, you might need to separate parts of that column (using SUBSTR and INSTR, for example), apply TO_NUMBER to the result and then sort the result.