Oracle Database Discussions

Dear Guru's


I am having two table with parent - child relationship. My problem is when I am deleting a row from parent table the curresponding child row from child table also should be deleted.

My Primary table 'Employee, EMPID Primary key

Child table 'Privilage' inthis EMPID referencing the EMPID of Employee table

My need is when I am deleting a row from parent table the curresponding child row from child table also should be deleted

I issued the SQL query like,
delete from employee where empid='12345' cascade constraints;

Then it showing me error like,

ERROR at line 1:
ORA-00933: SQL command not properly ended


Please resolve my issue , Its Top urgent

Thanks & Cheers
Antony