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
- 5761 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what will we require to build project with the help of oracle
THE CHANNEL IN DATA COMMUNICATION CAN BE?
What are two of your strengths that you will bring to our QA/testing team?
how many types of operating system are avaliable?
why we use abstract word in abstract window toolkit in java language.
can we use commit,rollback in triggers and how?
Given an array of size n. It contains numbers in the range 1 to n. Each number is present at least once except for 1 number. Find the missing number
What is easiest way to get the PL/i compiler,I didn't have found the compiler in my library. Is there any extra cost if we want to access the PL/1 programs?Actually we r having Mainframe rented training Ids
When you deliver your C++ headers and C++ library of a class (what all can you change in the class so that application using your class does not need to recompile the code)
Given an array of size n. It contains numbers in the range 1 to n. Find the numbers which aren?t present.
What is %Type,%Rowtype?
how can we maintain the previous version scripts to new version.
If u need any fake experience certificate in software side, contact me at: vikramyadhav@gmail.com
Busy waiting is a method whereas a taskwaits for a given event by continiously checking for an event to occur. What is the main problem with this approach
Why did you ever become involved in QA/testing?
