Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> How do I sort on final digit of a number?

How do I sort on final digit of a number?

From: Wayne Menzie <waynem_at_bosmedtechdotcom.nospam>
Date: Wed, 19 Jan 2000 21:55:30 GMT
Message-ID: <8EC0A302Cwayneshammalammading@129.250.35.141>

I have a field that I need to sort on the final digit of a number like this:

Unsorted     Sorted
Test_id      Test_id
-------      -------
    101          101
    402          201
   1401          401
    201         1401
    202          202
    401          402

Is there any way to do this with SQL or PL/SQL?

Wayne Menzie Received on Wed Jan 19 2000 - 15:55:30 CST

This message: [ Message body ]
Next message: dwarakv_at_hotmail.com: "Help!!! LOV based on another field in WebDB."
Previous message: Cole Moody: "Starting Oracle Server without Intervention"
Next in thread: Sybrand Bakker: "Re: How do I sort on final digit of a number?"
Reply: Sybrand Bakker: "Re: How do I sort on final digit of a number?"
Reply: fumi: "Re: How do I sort on final digit of a number?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US