Oracle 从多个表中删除行 [英] Oracle deleting rows from multiple tables

问题描述

我正在尝试从多个表中删除行，但在 medewerkers m 中出现语法错误，

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;

好像删除语句有误?

推荐答案

做不到.它必须是三个单独的删除.

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;

这篇关于Oracle 从多个表中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！