Hi
plz send the solution to the query which is attached thru paint brush image
Printable View
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.
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