Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Correct sorting of report in sql query
Hi,
I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digit numbers.
For example;
I tried to take and sort the 2 digits with the SUBSTR function, but it didn't work. (ORDER BY SUBSTR (question_text, 1, 2) ASC)I would be very grateful if you could share what is the way I can solve this.
Regards,
Tagged:
0