EMP: NUMBER (4) EMPNO VARCHAR2 (10) ENAME VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7,2) SAL NUMBER (7,2) COMM NUMBER (2) DEPTNO DEPT: NUMBER (2) DEPTNO VARCHAR2 (14) DNAME VARCHAR2 (13)


- Delete the employee who has the longest employment in the company


EMP:<br>NUMBER (4)<br>EMPNO<br>VARCHAR2 (10)<br>ENAME<br>VARCHAR2 (9)<br>JOB<br>NUMBER (4)<br>MGR<br>HIREDATE<br>DATE<br>NUMBER (7,2)<br>SAL<br>NUMBER (7,2)<br>COMM<br>NUMBER (2)<br>DEPTNO<br>DEPT:<br>NUMBER (2)<br>DEPTNO<br>VARCHAR2 (14)<br>DNAME<br>VARCHAR2 (13)<br>

Extracted text: EMP: NUMBER (4) EMPNO VARCHAR2 (10) ENAME VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7,2) SAL NUMBER (7,2) COMM NUMBER (2) DEPTNO DEPT: NUMBER (2) DEPTNO VARCHAR2 (14) DNAME VARCHAR2 (13)

Jun 05, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?