Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table which contains all the employee details,
unfortunately there is mistake occured while entering the
data.
ex:
-------------------------------
empid empname gender address
-------------------------------
1 abcd f address1
2 defg m address2
3 ghth m address3
4 jkil f address4
write a update query that will change gender 'm' to 'f'
and 'f' to 'm'
- 2 Answers
- 5529 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
update employeedetails
set gender='m'
where gender='f'
update employeedetails
set gender='f'
where gender='m'
| Is This Answer Correct ? | 2 Yes | 2 No |
It isn't possible to me to write a single query.You can first assign another value like 'a' to one of two values.Then assign your required value to the other
"update table set gender='f' where gender='m'"
"update table set gender='m' where gender='a'"
| Is This Answer Correct ? | 1 Yes | 2 No |
what is microprocessor?
1.group by clause explain along with an example
Why did you ever become involved in QA/testing?
class A{ void me(){s.o.p("");} class B extends A{ void me() {s.o.p(" ");} class M{ A a=new B(); B b=new A(); a.me(); b.mne();} what is the output of this, how?
2 Answers Cosmos, HyTech Pro, WinSoft,
How do you initialize a static member of a class with return value of some function?
what you mean by mantis in IT interview? why we use mantis? advantage of mantis?
hoｗ　ｔo check single or double byte in struts
design a counter with the following repeated binary sequence: 0, 1, 2, 3, 4, 5, 6, 7, 8 using JK Flip Flop.
3 Answers College School Exams Tests, IBD, IBM, Ignou, IIIT, Nortech, TCS, UOS,
What are data structures?
You are given a dictionary of all valid words. You have the following 3 operations permitted on a word: delete a character, insert a character, replace a character. Now given two words - word1 and word2 - find the minimum number of steps required to convert word1 to word2. (one operation counts as 1 step.)
What language / script is used to validate web page
How can you incorporate a Datawindow to a Oracle8i stored procedure?
C 
