Home » SQL & PL/SQL » SQL & PL/SQL » Question about refernce with 2 condition in oracle (Oracle 11g)
icon5.gif  Question about refernce with 2 condition in oracle [message #419341] Fri, 21 August 2009 06:24 Go to next message
Strahlungsleck
Messages: 5
Registered: August 2009
Location: Karlsruhe
Junior Member

I have the following create table statement
and i can executed it without any problems. But I want to add
a second condition.
that the reference row of table have "ON DELETE CASCADE" and the
second condition "ON UPDATE CASCADE" but i don´t know how
and i didn´t find something about this.


CREATE TABLE customer
(
	ID int NOT NULL PRIMARY KEY, 
	c_NA VARCHAR2 ( 255 ) NOT NULL,
	c_NU VARCHAR2 ( 255 ),
	C_MA VARCHAR2 ( 255 ),
	c_PR VARCHAR2 ( 255 ),
	c_CU VARCHAR2 ( 255 ),
	c_PI smallint,
	p_ID INTEGER NOT NULL REFERENCES Geloescht ON DELETE CASCADE 
);
Re: Question about refernce with 2 condition in oracle [message #419345 is a reply to message #419341] Fri, 21 August 2009 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ON UPDATE CASCADE does not exist in Oracle.

Regards
Michel
Re: Question about refernce with 2 condition in oracle [message #419347 is a reply to message #419345] Fri, 21 August 2009 06:51 Go to previous messageGo to next message
Strahlungsleck
Messages: 5
Registered: August 2009
Location: Karlsruhe
Junior Member

Michel Cadot wrote on Fri, 21 August 2009 13:43
ON UPDATE CASCADE does not exist in Oracle.

Regards
Michel



Hey Michel, thanks for your answer.
Do u know where i can read which refrences condition
are available for Oracle or give it an other
condition which do the same ?

Re: Question about refernce with 2 condition in oracle [message #419351 is a reply to message #419347] Fri, 21 August 2009 07:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Documentation
Previous Topic: Trigger for two tables
Next Topic: Use Associative Arrays in sql
Goto Forum:
  


Current Time: Sat Dec 03 10:12:50 CST 2016

Total time taken to generate the page: 0.08760 seconds