Interested to Buy Any Domain ? << Click Here >> for more details...
One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement.
- 6 Answers
- 16276 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / selvaraj anna university coe
UPDATE Eptbl SET Sex=DECODE
(Sex,'Male','Female','Female','Male');
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to create an oracle testing table?
How many data types are supported?
What is a dynamic performance view in oracle?
How to delete a user account in oracle?
How to insert a record into a table?
Why cursor variables are easier to use than cursors?
Can we convert a date to char in oracle and if so, what would be the syntax?
What privilege is needed for a user to insert rows to tables in another schema?
How are extents allocated to a segment?
How to define a variable to match a table column data type?
Can multiple columns be used in group by in oracle?
What are the advantages of oracle?
How to retrieve data from an explicit cursor?
How to export data with a field delimiter?
Explain integrity constraint?
