A column contains possible values like 'A', 'B', 'C'...'Z', 'AA', 'AB'... until 'ZZ'. This type of column is present in a lot of tables...
oracle MAX function returns 'Z' as greater the 'AA'. I want a function which returns 'AA' to be greater than 'Z'
Basically i am trying to achieve something like
SELECT MAX_CUSTOM(column_name) FROM TABLE_NAME WHERE...;;
If it is single table i could write my own function but i need to use this function on different tables.
How to achieve this? Any pointers would be greatful.