Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14272 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 is called partitioned primary index (ppi)?
What are the enhanced features in teradata v2r5 and v2r6?
In general, how do you optimze any sql in teradata?
How is MLOAD Teradata Server restarted after execution?
What are the various etl tools in the market?
What are the different design perspectives used in teradata?
What are the primary characteristics of the Teradata.
What are the functions performed by bynet?
What are the different methods ot loading a dimension table? A fact table etc?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How can we check the version of Teradata that we are using currently?
What is bteq utility in teradata?
How will you solve the problem that occurs during update?
When tpump is used instead of multiload?
Describe the between keyword in teradata?
