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 does sleep function does in fast load?
What are the design features involved in teradata?
Name the five phases that come under MultiLoad Utility.
What do you mean by tpt in teradata?
What are the different functions included in the server software?
How do you determine the number of sessions?
What is partitioned primary index (ppi)?
What is logical data model?
What do you mean by fastexport in teradata?
What are the frequently used data types in teradata?
What are the different design perspectives used in teradata?
Explain and compare pros and cons of snow flake schemas?
What is meant by a Least Cost Plan?
How is MLOAD Teradata Server restarted after execution?
What is the use of having index on table?