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 / 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
How to loop through data rows in the implicit cursor?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is there an oracle sql query that aggregates multiple rows into one row?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
what are the advantages of running a database in archive log mode?
What is a nested table?
Is oracle a relational database?
What happens if the imported table already exists?
What are the tools for 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?
What are the differences between blob and clob in oracle?
ABOUT IDENTITY?
What are the execution control statements in oracle?