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.
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
How to Truncate Table in Oracle
How can you use check constraints for self referential integrity?
interview questions with answer for cts
Explain the difference between a procedure and a function?
Why should I use oracle database?
What is null value in oracle?
What is a trigger and what are its types?
What is primefaces used for?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Which is better Oracle or MS SQL? Why?
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.
How to load a large xml file?
What is the difference between a hot backup and a cold backup in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How many types of database triggers exist?