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
- 16061 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
Differentiate between function and procedure in oracle.
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to get a list of all background sessions in the database?
How to load data from external tables to regular tables?
What privilege is needed for a user to delete rows from tables in another schema?
What are the differences between date and timestamp in oracle?
How do I connect to oracle?
How to divide query output into groups in oracle?
Give the various rollback segment states.
What privilege is needed for a user to create tables in oracle?
Explain the use of analyse option in exp command.
Explain the difference between a procedure and a function? What do you understand by those terms?
Oracle
What do you mean by merge in oracle and how can we merge two tables?
how to clone 9i Database on to 10g Database.
