HOW TO SORT A COLUMN WITH ALPHANUMERIC
I have a table named "BILLSCHARTS" with so many columns. I want to display the record and sort it by title.
The title column is a text value and example of the values are
HB 02 : Fiscal Policy Act
HB 35: Appropriation Act
HB 03 : Labour Law
HB 21: Appropriation Amendment Act
HB 14: Money Laundering Prohibition Act
I want to sort the table and have the following example as the output in that order:
HB 02 : Fiscal Policy Act
HB 03 : Labour Law
HB 14: Money Laundering Prohibition Act
HB 21: Appropriation Amendment Act
HB 35: Appropriation Act
Although, i have tried but the result am getting is displaying zeros first, then 1's , 2's , 3's etc.
I need your kind assistance with the sql query to use in achieving my goal.
Your kind assistance will be valued.
Thanks
Subject
Written By
Posted
HOW TO SORT A COLUMN WITH ALPHANUMERIC
April 28, 2016 08:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.