Hi...
I have a Question in Oracle.. Please give me the SQL Statement for the following condition. I have a table with columns name, gender. In that table i have 20 in which 10 rows are having Gender as "Male" and the rest of the rows are having a gender as "Female". Now i need to convert the Gender column as Males to Female & Females to Male. Is it posible to make this in a single query. please give me.