Помогите пожалста....!!!!
Последнюю сессию заканчиваю...
Через четыре дня экзамен по С, а ещё и работать надо..
Мне работу по курсу Оракла надо здать...
Несколько SELECT ну и пару PL...
Кому не лень, вот таблицы...
Если можете, пошлите на EMAIL: nudelsteeve@yahoo.com ...

DROP TABLE CUSTOMER;
DROP TABLE EMPLOYEE;
DROP TABLE DEPARTMENT;
DROP TABLE STATES;

CREATE TABLE "CUSTOMER" (
"ID" NUMBER(5, 0) NOT NULL,
"FNAME" VARCHAR2(15) NOT NULL,
"LNAME" VARCHAR2(20) NOT NULL,
"ADDRESS" VARCHAR2(35) NOT NULL,
"CITY" VARCHAR2(20) NOT NULL,
"STATE" VARCHAR2(2) NOT NULL,
"ZIP" VARCHAR2(10) NOT NULL,
"PHONE" VARCHAR2(12) NOT NULL,
"COMPANY_NAME" VARCHAR2(35)) ;
ALTER TABLE "CUSTOMER" ADD CONSTRAINT "CUST_PK" PRIMARY KEY ("ID") ;

CREATE TABLE "EMPLOYEE" (
"EMP_ID" NUMBER(5, 0) NOT NULL,
"MANAGER_ID" NUMBER(5, 0),
"EMP_FNAME" VARCHAR2(20) NOT NULL,
"EMP_LNAME" VARCHAR2(20) NOT NULL,
"DEPT_ID" NUMBER(5, 0) NOT NULL,
"STREET" VARCHAR2(40) NOT NULL,
"CITY" VARCHAR2(20) NOT NULL,
"STATE" VARCHAR2(4) NOT NULL,
"ZIP_CODE" VARCHAR2(9) NOT NULL,
"PHONE" VARCHAR2(10),
"STATUS" VARCHAR2(1),
"SS_NUMBER" VARCHAR2(11) NOT NULL,
"SALARY" NUMBER(20, 3) NOT NULL,
"START_DATE" DATE NOT NULL,
"TERMINATION_DATE" DATE,
"BIRTH_DATE" DATE,
"BENE_HEALTH_INS" VARCHAR2(1),
"BENE_LIFE_INS" VARCHAR2(1),
"BENE_DAY_CARE" VARCHAR2(1),
"SEX" VARCHAR2(1)) ;
ALTER TABLE "EMPLOYEE" ADD CONSTRAINT "EMP_PK" PRIMARY KEY ("EMP_ID") ;

CREATE TABLE "DEPARTMENT" (
"DEPT_ID" NUMBER(5, 0) NOT NULL,
"DEPT_NAME" VARCHAR2(40) NOT NULL,
"DEPT_HEAD_ID" NUMBER(5, 0)) ;
ALTER TABLE "DEPARTMENT" ADD CONSTRAINT "DEPT_PK" PRIMARY KEY ("DEPT_ID") ;

CREATE TABLE "STATES" (
"STATE_ID" VARCHAR2(3) NOT NULL,
"STATE_NAME" VARCHAR2(24) NOT NULL,
"STATE_CAPITAL" VARCHAR2(24) NOT NULL,
"COUNTRY" VARCHAR2(3) NOT NULL) ;
ALTER TABLE "STATES" ADD CONSTRAINT "STATES_PK" PRIMARY KEY ("STATE_ID","STATE_CAPITAL") ;