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)

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 - -
1 - 8

Explanation / Answer

2.SQL> Select ename, salary, and department number Fom emp where ename='Adama'; 6.SQL> Select employee_number,ename Fom emp where ename 'Asmith' or 'scott';

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---