Interested to Buy Any Domain ? << Click Here >> for more details...
Interchange the value of a column Gender in a table where
values are Male and Female. So, where the value is Male, it
should changed to Female and Female to Male.
- 4 Answers
- 19691 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / sushma s
Update table_name
Set gender = decode(gender,'M','F','M');
| Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
what are properties of a transaction? : Sql dba
Can pl sql procedure have a return statement?
How many types of triggers exist in pl/sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How do I run pl sql in sql developer?
What are schema-level triggers?
What is the difference between view and stored procedure?
How many types of normalization are there?
What is bind variable in pl sql?
Is primary key clustered or nonclustered?
How does index help in query performance?
What are the 3 types of behavioral triggers?
Explain polymorphism in pl/sql.
What are conditional predicates?
What is sqlerrm?
