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
- 15970 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
How to get last row id?
How to use "if" statements on multiple conditions?
What is primefaces used for?
What is MTTR advisor in Oracle?
Will you be able to store pictures in the database?
What are the extensions used by oracle reports?
Briefly explain what is literal? Give an example where it can be used?
In oracle there is column command, how will you explain that?
How can Oracle users be audited?
What is the quickest way to fetch the data from a table?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
When do you get a .pll extension in oracle?
What is a nested table?
What do database buffers contain?
Explain the use of control file?
