Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sort Employee Number

957471Sep 19 2013 — edited Sep 20 2013

Hi Experts,

   

        I'm using OBIEE 11.1.1.5(11g) and Datasource has Oracle SQL Developer.I have a scenario where I need to sort the employee Number in report and column is Varchar2.Since,this column contain alphanumeric.I couldnot cast the column into integer.I need to sort the data in ascending order.

Example:           Result need to be:

1                             1

10                           2

100                         10

2                            100

.                                .

.                                .

abc12                     abc1

abc1                      abc12


Hope i'm clear.Plz suggest me a solution.

Thanks in advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details