Re: ON DELETE CASCADE PROBLEM
Date: Mon, 22 Dec 2003 12:11:36 -0500
Message-ID: <bs78k9$me72_at_eccws12.dearborn.ford.com>
Huh?
SQL> insert into pelates values (1,'row 1 col 2', 'row 1 col 3')
2 /
1 row created.
SQL> insert into pelates values (2,'row 2 col 2', 'row 2 col 3') 2 /
1 row created.
SQL> insert into aytokinhta values (1, 'row 1 col 2', 'row 1 col 3', 'col4',
1 )
2 /
1 row created.
SQL> insert into aytokinhta values (2, 'row 2 col 2', 'row 2 col 3', 'col4',
2 )
2 /
1 row created.
SQL> select * from pelates
2 /
KODIKOS_PELATH ONOMATEPONYMO POLH -------------- ------------------------------ --------------- 2 row 2 col 2 row 2 col 3 1 row 1 col 2 row 1 col 3
SQL> select * from aytokinhta
2 /
KODIKOS_AYTOKINHTOY KATASKEYASTHS MONTELO PINAKID
------------------- -------------------- -------------------- -------KODIKOS_IDIOKTHTH
2 row 2 col 2 row 2 col 3 col4 2 1 row 1 col 2 row 1 col 3 col4 1
SQL> delete from pelates where kodikos_pelath = 1 2 /
1 row deleted.
SQL> select * from pelates
2 /
KODIKOS_PELATH ONOMATEPONYMO POLH -------------- ------------------------------ --------------- 2 row 2 col 2 row 2 col 3
SQL> select * from aytokinhta
2 /
KODIKOS_AYTOKINHTOY KATASKEYASTHS MONTELO PINAKID
------------------- -------------------- -------------------- -------KODIKOS_IDIOKTHTH
2 row 2 col 2 row 2 col 3 col4 2
SQL> delete from pelates where kodikos_pelath = 2 2 /
1 row deleted.
SQL> select * from pelates
2 /
no rows selected
SQL> select * from aytokinhta
2 /
no rows selected
"kotsos" <fakidomitis_at_yahoo.gr> wrote in message
news:bs5114$630$1_at_usenet.otenet.gr...
> Hi ...
>
> I'm a newbie in Oracle 8i and I have the following problem:
>
> I created two tables as follows:
> CREATE TABLE pelates
>
> (kodikos_pelath NUMBER(5,0) NOT NULL,
>
> onomateponymo VARCHAR2(30) NOT NULL,
>
> polh VARCHAR2(15) NOT NULL)
>
> /
>
> ALTER TABLE pelates
>
> ADD CONSTRAINT pk_kodikos_pelath PRIMARY KEY (kodikos_pelath)
>
> /
>
>
>
> CREATE TABLE aytokinhta
>
> (kodikos_aytokinhtoy NUMBER(5,0) NOT NULL,
>
> kataskeyasths VARCHAR2(20),
>
> montelo VARCHAR2(20),
>
> pinakida VARCHAR2(7) NOT NULL,
>
> kodikos_idiokthth NUMBER(5,0) NOT NULL)
>
> /
>
> ALTER TABLE aytokinhta
>
> ADD CONSTRAINT pk_kodikos_aytokinhtoy PRIMARY KEY (kodikos_aytokinhtoy)
>
> /
>
> ALTER TABLE aytokinhta
>
> ADD CONSTRAINT fk_to_pelates FOREIGN KEY (kodikos_idiokthth)
>
> REFERENCES pelates (kodikos_pelath)on delete cascade
>
> /
>
>
>
>
>
> ... and I filled them with values
>
> But whenever I try to delete some rows from pelates, then a message
appears
> concerning the foreign key constraint (of table aytokinhta) although I
> declared the "on delete cascade" option....
>
>
>
> Any ideas?
>
>
>
>
>
> Thank you...
>
>
>
>
>
>
>
>
Received on Mon Dec 22 2003 - 18:11:36 CET