本文介绍了Oracle 从多个表中删除行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
我正在尝试从多个表中删除行，但在 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 从多个表中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！