Display a function that computes a 3.5% raise for an employee. The employee salary will be passed
Fantastic news! We've Found the answer you've been seeking!
Question:
Display a function that computes a 3.5% raise for an employee. The employee salary will be passed as a parameter. Be sure to explicitly code the parameter mode. Code one exception that handles any types of error and returns NULL. Reminder: There are only 2 decimal places acceptable when displaying currency.
Table: employees.
Function name: func_exam2.
Code the SQL statement that is needed to provide the employee id, name, and the original and updated salary for all employees in the IT department (department 60). Order the result set from highest salary to lowest salary.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: