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???
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 is a clique?
Why teradata is used?
What is oltp?
What is collect statistics?
How you will check the version of teradata?
When tpump is used instead of multiload?
Explain and compare pros and cons of start schemas?
Why managing the data is important?
What is the purpose of joins in teradata?
Did you write stored procedures in teradata?
How many types of joins are there in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is teradata? Also, list out some of the primary characteristics of teradata.
Write a program to show the parser component used in teradata?
How can bottlenecks be identified?