بسم الله الرحمن الرحيم

اليكم حل اسئلة الكتاب الخاصه بفصل انشاء الجداول...


بسم الله :

CREATE TABLE dept
(id NUMBER(7)CONSTRAINT department_id_pk PRIMARY KEY,
name VARCHAR2(25));

DESCRIBE dept

INSERT INTO dept
SELECT department_id, department_name
FROM departments;

CREATE TABLE emp
(id NUMBER(7),
last_name VARCHAR2(25),
first_name VARCHAR2(25),
dept_id NUMBER(7)
CONSTRAINT emp_dept_id_FK REFERENCES dept (id)
);

DESCRIBE emp

CREATE TABLE employees2 AS
SELECT employee_id id, first_name, last_name, salary,
department_id dept_id
FROM employees;

DROP TABLE emp;

متابعيين معاك ان شاء الله