Oracle SQL
Create a function that sums two numbers if either of the two numbers is larger than 10; otherwise, it will multiply the two numbers.
Create a stored procedure that inserts a row into the myemployees table; the values must be passed as arguments to the procedure.
Create a trigger on the myemployees table that will do the following on insert:
- Add 100 to the inserted salary if the salary is more than 5000.
- Subtract 150 from the inserted salary if the salary is less than or equal to 5000.
Note: The myemployees table is a copy of the hremployees table. You can create it using the following statement: CREATE TABLE myemployees AS SELECT * FROM hremployees.
