Interchange the value of a column Gender in a table where
values are Male and Female. So, where the value is Male, it
should changed to Female and Female to Male.
- 4 Answers
- 18777 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / parli jain
Update table_name
set Gender = decode (Gender, 'M', 'F', 'F,'M')
where Gender In ('M','F');
| Is This Answer Correct ? | 29 Yes | 4 No |
Post New Answer View All Answers
What is the sql query to display the current date?
What is use of trigger?
Does oracle use sql?
Does sap use sql?
what is a materialized view? : Sql dba
What is view? Can we update view
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How many types of sql are there?
What do you understand by pl/sql cursors?
What is the basic structure of an sql?
What does select count (*) mean in sql?
What are inner outer left and right joins in sql?
Which join is like inner join?
what is user defined functions? : Sql dba
What is rename in sql?
