id name gender
1 Ram Female
2 Kumar Female
3 sathish Female
4 Santhya Male
5 Durga Male
6 Priya Male
This is my input...how to change Gender Male to Female &
Female to Male??? Write sql query for this question???
- 6 Answers
- 12091 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / srinu
update stud set gender= decode(gender,'M','F','F','M')
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What do you mean by teradata intellicloud?
What are the different design perspectives used in teradata?
What is a level of granularity of a fact table?
Difference between inner join and outer join?
Which is faster fastload or multiload?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is teradata?
How do you do backup and recovery in teradata?
What interface is used to connect to windows based applications?
What is node? How many nodes and amps used in your previous project?
What is meant by a Least Cost Plan?
Explain the term 'database' related to relational database management system?
How many sessions of MAX is PE capable of handling at a particular time?
What is a node in teradata? Explain
What is primary index and secondary index?
