CODEWITHSUNDEEP
sqloracle-databaseplsql
J. Adam
J. Adam

Reputation: 1641

Oracle deleting rows from multiple tables

i'm trying to delete rows from multiple tables but i'm getting a syntax error at medewerkers m,

Can anyone tell me what i'm doing wrong here? :

declare
v_mnr medewerkers.mnr%type;
procedure ontsla_med(p_mnr in medewerkers.mnr%type)
IS
BEGIN
    DELETE FROM medewerkers m, INSCHRIJVINGEN i , UITVOERINGEN u WHERE m.MNR = p_mnr and i.cursus = p_mnr and u.docent = p_mnr;
END ontsla_med;
BEGIN
    ontsla_med(7000);
END;

Seems like the delete statement is wrong?

Upvotes: 1

Views: 3004

Answers (1)

Error_2646
Error_2646

Reputation: 3849

Can't do it. It has to be three separate deletes. 

DELETE 
  FROM medewerkers
 WHERE mnr = p_mnr;

DELETE 
  FROM UITVOERINGEN 
 WHERE cursus = p_mnr;

DELETE 
  FROM UITVOERINGEN 
 WHERE docent = p_mnr;

Upvotes: 6

Related Questions