Thank you very much in advance for your help!!!! Unit 4 Assignment 1 Directions

Question

Thank you very much in advance for your help!!!!
Unit 4 Assignment 1
Directions
Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
All questions should be answered with one SQL statement.

1. Change the department number of all employees with employee 7900’s job title to employee 7900’s current department number. (use the emp table)

5. Delete the information from the spec_emp table for all employees who have the same job as Smith. (Use the emp table )

Column Name Data Type Nullable Default Primary Key
EMPNO NUMBER(4,0) No - 1
ENAME VARCHAR2(10) No - -
JOB VARCHAR2(9) Yes - -
MGR NUMBER(4,0) Yes - -
HIREDATE DATE Yes - -
SAL NUMBER(7,2) Yes - -
COMM NUMBER(7,2) Yes - -
DEPTNO NUMBER(2,0) Yes - -

Explanation / Answer

1. Change the department number of all employees with employee 7900’s job title to employee 7900’s current department number. (use the emp table)

       SQL> update emp set jobtitle = 7900; 5. Delete the information from the spec_emp table for all employees who have the same job as Smith. (Use the emp table )

       SQL>  DELETE FROM spec_emp where job = (SELECT job FROM employee WHERE ename = ‘smith’); I Hope this would helpful for you....... I Hope this would helpful for you.......

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.