Chapter 8, Problem 12P

Explanation of Solution

UPDATE command:

• The UPDATE command is employed to update information present in a table.
• It is always used with SET keyword either in bulk or individually.

Syntax for update the value in the table is given as follows:

UPDATE table_name

SET column1 = data1, column2 = data2, ...

WHERE condition;

Update values into the table “EMP_1”:

UPDATE EMP_2

SET EMP_PCT = EMP_PCT + 0.15

WHERE EMP_FNAME = 'Maria'

AND EMP_LNAME = 'Alonzo'

AND EMP_INITIAL = 'D';

Explanation:

• The above query is used to update the values in the table “EMP_2”...