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
- 14488 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
Differentiate database data and data warehouse data?
Why teradata is used?
What does Amp contain and what are all the operations that it performs?
What do you mean by tpt in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is meant by Teradata Gateway?
How do you set the session mode parameters in bteq?
Explain the term 'database' related to relational database management system?
What is a clique?
how can we analyze the locks ?
Differentiate primary key and partition key?
Highlight all the modes that are present under Confidence Level.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is teradata? What are some primary characteristics of teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
