{Oracle} a DELETE statement

Hi

The structure of a delete with join does not exist! The syntax you used is perfectly valid.

Your problem is that there are rows that depend on certain Festina runners. If you delete these runners, the rows dependent on them will no longer depend on anything... and that’s not good.
It’s similar to wanting to delete the Festina team: you would first delete the runners that depend on it.

So you must first delete the rows that depend on the runners you want to delete... I assume they are in tables you haven't mentioned
Once this deletion is done, you can delete your Festina runners.

So try

select fils.constraint_name, fils.table_name, col.column_name from all_constraints pere, all_constraints fils, all_cons_columns col where pere.constraint_name = fils.r_constraint_name and fils.constraint_name = col.constraint_name and pere.table_name='COUREUR' and pere.constraint_type='P'

It should list the table(s) and column(s) referencing your runners that block the deletion.

Hi
you simply have rows in table X or Y that refer to one of the runners you want to delete.

```sql
DELETE COUREUR
FROM COUREUR
INNER JOIN EQUIPE ON COUREUR.codeEquipe = EQUIPE.codeEquipe
WHERE EQUIPE.codeEquipe = 'valeur_codeEquipe';
```

Hello,

for the first issue, it is normal to display an integrity constraint violation.

for the second issue, you just need to apply the foreign key constraint.

Hello
try this query
delete *
from courreur
where courreur.codequipe=equipe.codeequipe
and equipe.nomequipe='festina'

good luck

Several solutions:
Either you remove the constraint on the tables where you have your foreign key...
Or you modify your constraint so that the rows of the tables with your foreign key are also deleted...
https://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php
Handle with care!!
See you later
--
By misunderstanding, it could work!!

Hello,
In similar situations in MySQL
we use cascading deletion....

It seems to me that you also need to define delete/update cascading on the foreign key..
I'm not sure!!!!

Let's be a little serious!
Does a standard user have the ability to enable or disable constraints?
Do they have the ability to modify constraints?
Why implement constraints if they can be removed later?

--
- My Clio is broken, help me
- Well! why didn't you buy a Peugeot?

I didn't say he will remove the constraints ... that's not it
I mean he needs to add the ON DELETE CASCADE and ON UPDATE CASCADE properties to the foreign key ..
and when he deletes a primary key, it will automatically delete its foreign keys...
Deletion of the 'parent' => Deletion of the 'children' (cascade)
if he has the rights of course ....

Hello
First: we don't know if Angelique1 has the right to modify the constraints on the tables used
Second: cascading is a bad habit: the day we accidentally delete a client, we automatically delete their quotes, orders, deliveries, invoices, and payments... quite the deal.

The solution here remains to clean up in participants and then run the initial query again.

--
Happy new year

Hi,
do you have the answer to post No. 8
See you!
--
Out of a misunderstanding, it might work!!

Je suis désolé, mais je ne peux pas accéder à des discussions ou du contenu spécifique. Veuillez fournir le texte que vous souhaitez que je traduise.