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.
Answer Posted / murali mohan
Try this,
update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');
Regards,
Murali
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How translate command is different from replace?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
why dont we assign not null constraint as table level constraint.
What is Undo Management Advisor in Oracle?
Explain the features of oracle?
What is SQL Tuning Advisor in Oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain temporal data types in oracle
How many categories of data types?
What is a static data dictionary in oracle?
How to get a list of all user accounts in the database?
What are the uses of Database Trigger ?
What is an oracle and why it is used?
definition of cluster and non-clustered index?
What is merge statement used for?