The following programs demonstrate the use of the multiplication
(*) arithmetic operator and the MODIFY statement. These programs
select the record of an employee in the SALARY_HISTORY relation
with a specified employee ID and that has no value for SALARY_
END. The purpose of specifying no value for SALARY_END is to
ensure that the only salary amount affected is the employee's
present salary. Next, the programs multiply the employee's
salary by 1.1 to produce an increase of ten percent in his or
her salary. The MODIFY statement replaces the old value in this
employee's SALARY_AMOUNT field with the new value.
Additional Information:
explode
extract