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
- 16275 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / hitendra yadav
--Try this
UPDATE Eptbl
SET Sex= CASE WHEN SEX='Male'
THEN 'Female'
ELSE 'Male'
END;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between blob and clob in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to assign values to variables?
How to execute a stored program unit?
How to start a new transaction in oracle?
How can I see all tables in oracle?
What is BBED in Oracle?
What is a data lock in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What is the use of file param in imp command?
Explain the use of constraints option in exp command.
What is meant by an index?
How to create lov dynamically at runtime & attach to text field?
What is oracle used for?
