Hi,
I habe been stuck for days on a query, which now seems to me quite impossible to build.
For a list of bonds I have to calculate the median of three rating figures, which are in three separated columns and are unfortunately on text format (VARCHAR2).
For instance:
My idea would be to convert each Level of the 3 alphanumeric codes into a common and unique numerical ID (NUMBER Format).
For instance:
Then, I have to calculate the MEDIAN on the corresponding numbers, and this for each bond.
I cannot find a solution..
Please help.
NB: on my SQL Developer Desk I am only allowed to use the SELECT function.
Thanks a lot in advance for your assistance.
Cheers
Rani