查询1:WHERE Frequents.drinker NOT IN ( WHERE F.bar NOT IN SELECT bar FROM Sells, Likes WHERE Sells.beer = Likes.beer AND Likes.drinker = F.drinker ) SELECT Frequents.drinker FROM Frequents, S
我将在oracle中使用EXECUTE statement语句动态执行此sql语句。但是当我这样做时,我会得到一个错误‘缺失关键字’。我已经声明RULECOUNT变量为数字。当我移除INTO语句时,sql语句似乎被正确执行。from vw_rule_detail_search a WHERE a.Applicability = 'No' order by a.BT 我不知道发生了什么,神谕里有谁能帮我找到我错过的