Answer / parli jain

Update table_name
set Gender = decode (Gender, 'M', 'F', 'F,'M')
where Gender In ('M','F');

Answer / raghu

UPDATE TABLE_NAME
SET GENDER=( CASE GENDER
WHEN 'M' THEN 'F'
WHEN 'F' THEN 'M'
END )
WHERE GENDER IN('M','F')

Answer / ram

UPDATE TABLE
SET GENDER=(CASE GENDER
WHEN 'M' THEN 'F'
WHEN 'F' THEN 'M'
END) WHERE GENDER IN ('M','F')

Answer / sushma s

Update table_name
Set gender = decode(gender,'M','F','M');

Does mysql support pl sql?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

What are the different sql commands?

0 Answers  

---

What is sql used for?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

---

Is time a data type in sql?

0 Answers  

---

What is date functions?

0 Answers  

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---

what is self join and why is it required? : Sql dba

1 Answers  

---