Re: update restrict question...

That's not official syntax isn't it (docs are online at http://technet.oracle.com) the right parenthesis is redundant and the update restrict doesn't exist in Oracle (the last version I know is 8.1.5 and it doesn't exist in that version)

Regards,

Sybrand Bakker, Oracle DBA

<AWI> wrote in message news:39c83a79_at_naylor.cs.rmit.edu.au...
>
> I get the following error :
>
>
> ON UPDATE RESTRICT)
> *
> ERROR at line 9:
> ORA-00907: missing right parenthesis
>
>
> ON UPDATE RESTRICT)
> *
> ERROR at line 10:
> ORA-00907: missing right parenthesis
>
> from the following,
>
> DROP TABLE FULLTIMESTAFF;
> DROP TABLE PARTTIMESTAFF;
> DROP TABLE EMPLOYEE;
>
> CREATE TABLE EMPLOYEE (
> EMPLOYEEID VARCHAR2(10) NOT NULL,
> FIRSTNAME VARCHAR2(10) NOT NULL,
> LASTNAME VARCHAR2(10) NOT NULL,
> ADDRESS VARCHAR2(50),
> GENDER VARCHAR2(1),
> AGE NUMBER(3),
> CONTACTPERSON VARCHAR2(20),
> CONTACTPERSONADDRESS VARCHAR2(50),
> EMPLOYEETYPE VARCHAR2(20) NOT NULL
> CHECK (EMPLOYEETYPE IN ('FULLTIMESTAFF', 'PARTTIMESTAFF')),
> PRIMARY KEY (EMPLOYEEID));
>
> CREATE TABLE FULLTIMESTAFF (
> EMPLOYEEID VARCHAR2(10) NOT NULL,
> ANNUALSALARY NUMBER(7,2),
> ANNUALLEAVE INTEGER,
> PERKSALLOWED VARCHAR2(100),
> PRIMARY KEY(EMPLOYEEID),
> FOREIGN KEY(EMPLOYEEID) REFERENCES EMPLOYEE
> ON DELETE CASCADE
> ON UPDATE RESTRICT);
>
> CREATE TABLE PARTTIMESTAFF (
> EMPLOYEEID VARCHAR2(10) NOT NULL,
> CASUALRATE NUMBER(3,2),
> HOURSWORKED NUMBER(3,2),
> EMPLOYEETYPE VARCHAR2(20)
> CHECK (EMPLOYEETYPE IN ('CONTRACTSTAFF')),
> PRIMARY KEY (EMPLOYEEID),
> FOREIGN KEY (EMPLOYEEID) REFERENCES EMPLOYEE
> ON DELETE CASCADE
> ON UPDATE RESTRICT);
>
> can anyone help?
> thanks!!
>
>
>
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT