Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE TABLE EMP ( EMPNO NUMBER ( 6 ) NOT NULL, ENAME VARCHAR 2 ( 2 0 ) , JOB VARCHAR 2 ( 1 0
CREATE TABLE EMP
EMPNO NUMBER NOT NULL,
ENAME VARCHAR
JOB VARCHAR
MGR NUMBER
DEPTNO NUMBER
SAL NUMBER
PRIMARY KEY EMPNO
;
CREATE TABLE DEPT
DEPTNO NUMBER
DNAME VARCHAR
LOC VARCHAR
PRIMARY KEY DEPTNO
;
ALTER TABLE EMP ADD CONSTRAINT FKDEPTNO FOREIGN KEY DEPTNO REFERENCES DEPTDEPTNO;
INSERT ALL
INTO EMP EMPNO ENAME, JOB, MGR DEPTNO, SAL VALUES 'REHAB', 'MANAGER',
INTO EMP EMPNO ENAME, JOB, MGR DEPTNO, SAL VALUES 'MAAZ', 'MANAGER',
INTO EMP EMPNO ENAME, JOB, MGR DEPTNO, SAL VALUES 'ALI', 'CLERK',
INTO EMP EMPNO ENAME, JOB, MGR DEPTNO, SAL VALUES 'MAT', 'ARCHITECT',
INTO DEPT DEPTNO DNAME, LOC VALUES IT 'ABHA'
INTO DEPT DEPTNO DNAME, LOC VALUES IS 'JAZAN'
INTO DEPT DEPTNO DNAME, LOC VALUES 'CNET', 'RIYADH'
SELECT FROM dual;
ALTER TABLE EMP ADD CONSTRAINT checkempno CHECK EMPNO ;
ALTER TABLE EMP ADD DOB DATE;
UPDATE EMP SET SAL SAL WHERE JOB 'MANAGER';
CREATE TABLE MANAGER AS SELECT FROM EMP WHERE JOB 'MANAGER';
SELECT EENAME, DDNAME FROM EMP E RIGHT OUTER JOIN DEPT D ON EDEPTNO DDEPTNO;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started