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
- 15964 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / apsar
update tbl_name set (a,b) = (select b,a from tbl_name where a='Male');
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can a parameter be passed to a cursor?
What happens to the current transaction if the session is ended?
How do I limit the number of rows returned by an oracle query after ordering?
interview questions with answer for cts
How do we display rows from the table without duplicates?
Explain the use of parfile option in exp command.
How to get execution path reports on query statements?
What is a data lock in oracle?
How to export data with a field delimiter?
What happens to the current transaction if a ddl statement is executed?
How index is implemented in oracle database?
Where are the settings stored for each instance in oracle?
Explain the truncate in oracle?
What are the differences between number and binary_float in oracle?
Can we create trigger on materialized view in oracle?
