找出如果删除表中的一行将删除(级联)多少行 [英] Find out how many rows that will be deleted(on cascade) if one row in a table is deleted

问题描述

是否可以找出在表中删除一行后将在每个表中删除的行数?

is it possible to find out the amount of rows that will be deleted in each table when one row is deleted in a table?

例如，我在产品表中有一行.我删除了一个产品，并且由于我已经使用了删除级联，因此将删除不同表中的其他行，例如注释和价格.是否有可能获得要从其他表中删除的行数作为字符串?

For example, I have a row in a product table. I deleted a product and since i have use on delete cascade, the other rows in different tables such as Comments and Price will be deleted. Is it possible to get the amount of rows that will be deleted from the other tables as a string?

示例输出将是三行评论将被删除\ n1行价格将被删除"预先感谢！

The sample output will be "3 rows of comment will be deleted\n 1 rows of price will be deleted" Thanks in advance!

推荐答案

查看此答案，这可能有助于您解决问题.

Check Out This Answer, This may help you to Solve your Problem.

Oracle Delete语句:如何许多行已通过级联删除删除

这篇关于找出如果删除表中的一行将删除(级联)多少行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！