Oracle string, number, special symbol, sorting

Please record Oracle strings, numbers, special symbols, and sorting problems after they are solved. It may be used at some time. Not to mention, positive T; requirement (changed based on different requirements): Sort string format: field Test course coefficient [2013] No. 29 course No. [2012] No. 233 Course Arrangement [2013] No. 44 Course Arrangement [2012] NO. 1 course arrangement [2012] NO. 34... ......... according to the requirements, the Test course No. [2012] No. 233 Course Arrangement [2013] No. 44 Course Arrangement [2012] NO. 34 course coefficient [2013] No. 29 Course Arrangement [2012] 1 after some tests and summary by our predecessors, you can use the following SQL code to_number (translate (Test, '20160301' | Test, '20160301') to view the SQL code to_number (substr (Test, instr (Test, ']') + 1, length (Test)-(instr (Test, ']') + 1) desc, in addition, any combination of numbers and strings may result in incorrect sorting, for example, ----------------------------------- tax No. 204 tax No. 205 tax No. 206 tax No. 207. The sorting result is: tax No. 204 tax No. 205 tax No. 207 -----------------------------------