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 / 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
What are the various types of snapshots ?
how may join possible between (requisition with purchase order)
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to update values on multiple rows in oracle?
What privilege is needed for a user to connect to oracle server?
What is meant by recursive hints in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to create a stored function in oracle?
What are a collation and state the different types of collation sensitivity?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to shutdown your 10g xe server from command line?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How many types of database triggers exist?
what is port in oracle? how is it related to database application.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?