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
- 15867 Views
- Polaris, I also Faced
- E-Mail Answers
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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to use "if" statements on multiple conditions?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is an oracle table?
What are the system predefined user roles?
Please explain oracle data types with examples?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to define an anonymous procedure with variables?
How to get last row id?
What is a database schema in oracle?
What is a read write transaction in oracle?
What are the set operators union, union all, minus & intersect meant to do?
what is insert all statement in sql
Why do we use coalesce function in oracle?
What is an external table?
