( karyawan_id NUMBER(6)
CONSTRAINT kar_karyawan_id PRIMARY KEY
,first_name VARCHAR2 (20)
,last_name VARCHAR2 (25)
CONSTRAINT kar_last_name_nn NOT NULL
,email VARCHAR2 (25)
CONSTRAINT kar_email_nn NOT NULL
CONSTRAINT kar_email_uk UNIQUE
,phone_number VARCHAR2 (20)
,hire_date DATE
CONSTRAINT kar_hir_date_nn NOT NULL
,job_id VARCHAR2 (10)
CONSTRAINT kar_job_nn NOT NULL
,salary NUMBER(8,2)
CONSTRAINT kar_salary_ck CHECK (salary>0)
,commision_pct NUMBER (6)
,department_id NUMBER (4)
CONSTRAINT kar_dept_fk REFERENCES
departments (department_id));
CREATE TABLE dept80
AS
SELECT employee_id ,last_name,
salary*12 ANNSAL,
hire_date
FROM employees
WHERE department_id =80;
CREATE TABLE empvu80
AS SELECT employee_id ,last_name,
salary
FROM employees
WHERE department_id =80;
CREATE VIEW SALvu50
AS SELECT employee_id ID_NUMBER,last_name NAME,
salary*12 ANN_SALARY
FROM employees
WHERE department_id =50;
SELECT *
FROM salvu50;
CREATE OR REPLACE VIEW empvu90
(id_number, name, sal,department_id)
AS SELECT employee_id,first_name || ' '
|| last_name, salary, department_id
FROM employees
Where department_id=80;
