Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL *Plus 8.0 - deleting foreign key

SQL *Plus 8.0 - deleting foreign key

From: <gekko_at_newsguy.com>
Date: Mon, 03 Jan 2000 02:55:36 GMT
Message-ID: <38700fa3.2952906@news.usenetserver.com> 





I am trying make sure that upon deletion, the datatype is set to null.
What is the proper syntax in SQL*Plus 8.0 for this? 
Here is what I tried:



13 FOREIGN KEY (REP)



14 REFERENCES SALESREPS



15 ON DELETE SET NULL


I got this:


ERROR at line 15:


ORA-03001: unimplemented feature



Thanks,


bobdobbs




Received on Sun Jan 02 2000 - 20:55:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US