CREATE TABLE EMP

$($

EMPNO NUMBER$(6)$ NOT NULL,

ENAME VARCHAR$2(20),$

JOB VARCHAR$2(10),$

MGR NUMBER$(4),$

DEPTNO NUMBER$(3),$

SAL NUMBER$(7,2),$

PRIMARY KEY $($EMPNO$)$

$)$;

CREATE TABLE DEPT

$($

DEPTNO NUMBER$(2),$

DNAME VARCHAR$2(10),$

LOC VARCHAR$2(10),$

PRIMARY KEY $($DEPTNO$)$

$)$;

ALTER TABLE EMP ADD CONSTRAINT FK$\_$DEPTNO FOREIGN KEY $($DEPTNO$)$ REFERENCES DEPT$($DEPTNO$)$;

INSERT ALL

INTO EMP $($EMPNO$,$ ENAME, JOB, MGR$,$ DEPTNO, SAL$)$ VALUES $(103,$ 'REHAB', 'MANAGER', $1236,12,7500)$

INTO EMP $($EMPNO$,$ ENAME, JOB, MGR$,$ DEPTNO, SAL$)$ VALUES $(101,$ 'MAAZ', 'MANAGER', $1234,10,5600)$

INTO EMP $($EMPNO$,$ ENAME, JOB, MGR$,$ DEPTNO, SAL$)$ VALUES $(102,$ 'ALI', 'CLERK', $1235,11,3500)$

INTO EMP $($EMPNO$,$ ENAME, JOB, MGR$,$ DEPTNO, SAL$)$ VALUES $(104,$ 'MAT', 'ARCHITECT', $1236,12,5000)$

INTO DEPT $($DEPTNO$,$ DNAME, LOC$)$ VALUES $(10,\text{'}$IT$\text{'},$ 'ABHA'$)$

INTO DEPT $($DEPTNO$,$ DNAME, LOC$)$ VALUES $(11,\text{'}$IS$\text{'},$ 'JAZAN'$)$

INTO DEPT $($DEPTNO$,$ DNAME, LOC$)$ VALUES $(12,$ 'CNET', 'RIYADH'$)$

SELECT $*$ FROM dual;

ALTER TABLE EMP ADD CONSTRAINT check$\_$empno CHECK $($EMPNO $>100)$;

ALTER TABLE EMP ADD $($DOB DATE$)$;

UPDATE EMP SET SAL $=$ SAL $+1000$ WHERE JOB $=$ 'MANAGER';

CREATE TABLE MANAGER AS SELECT $*$ FROM EMP WHERE JOB $=$ 'MANAGER';

SELECT E$.$ENAME, D$.$DNAME FROM EMP E RIGHT OUTER JOIN DEPT D ON E$.$DEPTNO $=$ D$.$DEPTNO;