December 28th, 2003, 07:06 PM
Newbie Select Problem...
I am a newbie in Oracle, I now having a problem, that is, I have a table of some students, in which there is a column showing their gender (char(1)), and the data inside are 'f' or 'm'.
Now the question is, I want to display it when it is 'f', it show me 'female', when it is 'm', it show me 'male'...
I really wonder if it is possible to do so... I modified the gender column to varchar2(10) so that it can let me display more than one characters, but I still don't know how to display it as female or male.
Thank you very much
December 28th, 2003, 07:07 PM
December 28th, 2003, 07:19 PM
Thank you so much for you instant reply!! I now understand how to do.