(PL/SQL) the command need to work on Oracle. just post the command and I will check it in my Oracle. Create a trigger on MyEmployees table that will change salary to 0 if a new row is inserted where...

(PL/SQL) the command need to work on Oracle. just post the command and I will check it in my Oracle. Create a trigger on MyEmployees table that will change salary to 0 if a new row is inserted where salary is NULL.  Note: MyEmployees table is a copy of hr.employees table. You can create it using the following statement CREATE TABLE MyEmployees AS SELECT * FROM hr.Employees
EMPLOYEES<br>I EMPLOYEE_ID<br>FIRST_NAME<br>- LAST_NAME<br>-目EMAIL<br>-I PHONE_NUMBER<br>-I HIRE_DATE<br>国JOB_ID<br>目SALARY<br>COMMISSION_PCT<br>I MANAGER_ID<br>DEPARTMENT_ID<br>

Extracted text: EMPLOYEES I EMPLOYEE_ID FIRST_NAME - LAST_NAME -目EMAIL -I PHONE_NUMBER -I HIRE_DATE 国JOB_ID 目SALARY COMMISSION_PCT I MANAGER_ID DEPARTMENT_ID

Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here