You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Correct sorting of report in sql query

    edited Aug 10, 2023 6:49AM in Reporting and Analytics for HCM 2 comments

    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:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!