| sql question [message #347029] |
Wed, 10 September 2008 08:23  |
rakeshforum
Messages: 5
Registered: September 2008
Location: india
|
Junior Member |
|
|
hi everyone,
there is table called emp, in emp table there is column named
gender
gender
------
m
f
m
f
so on
with using single update statemant , update this column like whereever
m is there change it to f
f is there change it to f
i.e
above column became
gender
------
f
m
f
m
regards,
rakesh
|
|
|
|
| Re: sql question [message #347030 is a reply to message #347029] |
Wed, 10 September 2008 08:24  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
From your previous topic with the same meaningless and useless title:
| Michel Cadot wrote on Wed, 10 September 2008 14:43 | Also please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Regards
Michel
|
I add:
- Post what you already tried
- Post a test case: create table and insert statements along with the result you want with these data.
[Updated on: Wed, 10 September 2008 08:25] Report message to a moderator |
|
|
|
|
|
| Re: sql question [message #347048 is a reply to message #347047] |
Wed, 10 September 2008 09:14 |
|
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
@developer69
Don't put solution only hint or clue as requested in OraFAQ Forum Guide, "Responding to Posts" section:
| Quote: | When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usual to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, and not provide complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.
|
Regards
Michel
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
