Important Query

Hi

plz send the solution to the query which is attached thru paint brush image

Is that all you want? Or does your homework assignment require that you do the update with
a single update statement? If you you need to look at the case statement.

In the future you should really specify more detail when posting to the forum, or any forum.
Also don't include the png file that your teacher sent you, actually type the data. :rolleyes:

Code:

---

UPDATE emp
  SET salary = 7782
 WHERE emp_id = 7839;

UPDATE emp
  SET emp_id = 5000
 WHERE salary = 7782;

COMMIT;

---

so, you want to swap Clark's employee-id with King's salary?

I apologize if column names are not correct but, poster missed that particular little piece of information.

Quote:

---

Originally Posted by PAVB

so, you want to swap Clark's employee-id with King's salary?

I apologize if column names are not correct but, poster missed that particular little piece of information.

---

The table is directly from the scott sample schema. Even the data is from the default schema.
Not a very useful request. :rolleyes:

http://www.orafaq.com/wiki/SCOTT

Quote:

---

Originally Posted by muba

Hi

plz send the solution to the query which is attached thru paint brush image

---

it need to be done using single update statement

Quote:

---

Originally Posted by muba

it need to be done using single update statement

---

You need something like this.

Code:

---

UPDATE mubas_emo_table
  SET salary = CASE emp_id
                WHEN  7839 THEN 7782
                ELSE salary
                END,
      emp_id = CASE emp_id
                WHEN  7782 THEN 5000
                ELSE salary
 WHERE emp_id IN ( 7782, 7839 );

---