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
- 5760 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 |
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
What sysoption determines where the macro facility searches a specific catalog for complied macro?
What is the language used for Artificial Intelligence?
. With the help of above table EMP, perform the following operation is sql. a) Add the new column “DEPTNO” b) Rename the table c) Update table d) Modify the table if column ‘SAL’ whose data type is number (10) and you want to enter varchar2 (15) . For example $USD 20 etc.
Definition of Singleton Class? what is the Purpose of it? what is the advantage?
technical interview questions and process
what are importance in problem tracking
what diffrence between procedure and function?
what will we require to build project with the help of oracle
how does database connection using ADO.NET?
i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......
what is technical system, business system, logical system in sap pi7.0
C 
