Example

Increase the SQL variable p_salary by 10 percent.

  SET p_salary = p_salary + (p_salary * .10)

Set SQL variable p_salary to the null value

  SET p_salary = NULL