ORA-rr

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';

DROP TABLE hire;
DROP TABLE model;
DROP TABLE stock;
DROP TABLE customer;


CREATE TABLE model(
    Model_code  CHAR(5) PRIMARY KEY,
    Name        VARCHAR2(40),
    Mth_charge  Number(5,2)
    );

INSERT INTO model VALUES('AX323','50 cm National Colour TV',89.00);
INSERT INTO model VALUES('AX747','90 cm Sanyo Colour TV',169.00);
INSERT INTO model VALUES('BX111','4 channel integrated video rectifier',45.00);


CREATE TABLE stock(
    Stock_num   NUMBER(4) PRIMARY KEY,
    Model_code  CHAR(5),
    Condition   CHAR(1),
    Date_maint  DATE,
    FOREIGN KEY (Model_code) REFERENCES model(Model_code)
    );

INSERT INTO stock VALUES(2001,'AX323','E',NULL);
INSERT INTO stock VALUES(2002,'AX323','S','7-JUL-1991');
INSERT INTO stock VALUES(2003,'BX111','R',NULL);
INSERT INTO stock VALUES(2004,'AX323','E','6-JUN-1991');
INSERT INTO stock VALUES(2005,'AX747','E',NULL);
INSERT INTO stock VALUES(2006,'AX747','R','8-AUG-1991');


CREATE TABLE customer(
    Cust_num    NUMBER(4) PRIMARY KEY,
    Title       Char(3),
    Name        VARCHAR2(25)
    );

INSERT INTO customer VALUES(1001,'MR','Isaac Newton');
INSERT INTO customer VALUES(1002,'MS','Freda Bloggs');
INSERT INTO customer VALUES(1003,'DR','Stan Smith');
INSERT INTO customer VALUES(1004,'MS','Alice Smith');
INSERT INTO customer VALUES(1005,'MR','Max Miller');
INSERT INTO customer VALUES(1006,'DR','Zeg Zebra');


CREATE TABLE hire(
    Stock_num   NUMBER(4),
    Date_hired  DATE,
    Cust_num    NUMBER(4),
    Paid_till   DATE,
    Date_ret    DATE,
    FOREIGN KEY (Stock_num) REFERENCES stock(Stock_num),
    FOREIGN KEY (Cust_num) REFERENCES customer(Cust_num)
    );

INSERT INTO hire VALUES(2001,'1-JAN-1980',1005,'1-FEB-1980','1-FEB-1980');
INSERT INTO hire VALUES(2001,'5-JAN-1980',1001,'5-FEB-1990','5-MAR-1980');
INSERT INTO hire VALUES(2001,'8-MAR-1980',1002,'7-JUN-1990','8-JUN-1990');
INSERT INTO hire VALUES(2002,'8-MAR-1980',1002,'8-APR-1990','8-APR-1990');
INSERT INTO hire VALUES(2003,'5-JAN-1990',1001,'5-JUL-1990','5-JUL-1990');
INSERT INTO hire VALUES(2004,'5-JAN-1990',1001,'5-FEB-1990','5-FEB-1990');
INSERT INTO hire VALUES(2004,'1-FEB-1991',1001,'2-FEB-1992',NULL);
INSERT INTO hire VALUES(2005,'10-FEB-1991',1003,'12-DEC-1992',NULL);
INSERT INTO hire VALUES(2006,'1-JUL-1989',1003,'30-NOV-1989','30-NOV-1989');