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 define an oracle cursor variable?
How to join two tables in a single query using oracle?
How a tablespace is related to data files?
When do you get a .pll extension in oracle? Explain its importance
How do I spool to a csv formatted file using sqlplus?
How view is different from a table?
What is Virtual Private Database in Oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Does oracle partitioning improve performance?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How much memory your 10g xe server is using?
What are the different pseudo commands? Explain in general?
What is Library Cache in Oracle?
What is a proxy class?
what is reindexing?