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