update stud set gender= decode(gender,'M','F','F&#

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???

Question Posted / srinu

6 Answers
14022 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

Please Help Members By Posting Answers For Below Questions

What are the primary characteristics of the Teradata.

1059

What are the 5 phases in a multiload utility?

987

What are the various indexes in teradata? Why are they preferred?

959

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

935

What is dimensional modeling?

1015

What is partitioned primary index (ppi)?

1000

Difference between multiload and tpump?

1043

What do you mean by teradata intelliflex?

1039

How can we check the version of Teradata that we are using currently?

1014

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1062

In general, how do you optimze any sql in teradata?

976

Highlight the advantages of PPI(Partition Primary Index).

1006

List out all forms of LOCKS that are available in Teradata.

914

how do you manage the production space. what are the proactive methods you can take ?

1884

How many types of joins are there in teradata?

916