We need to write three queries, to solve this problem.
Table Name = EMP
Column name = GENDER
1) Update EMP set GENDER='TEMP' where GENDER= 'M'
2) Update EMP set GENDER='M' where GENDER= 'F'
3) Update EMP set GENDER='F' where GENDER='TEMP'
Table Name = EMP
Column name = GENDER
1) Update EMP set GENDER='TEMP' where GENDER= 'M'
2) Update EMP set GENDER='M' where GENDER= 'F'
3) Update EMP set GENDER='F' where GENDER='TEMP'
Hey Ravi nice to see that u started writing the blog keep going.. :)
ReplyDelete