你背后的原因是什么获取每一行的block_id并在临时表中输入并使用相同的方法来更新从中获得此块ID的表？

What is the reason behind you getting the block_id for each row and sotring in temp table and using the same to update the table from which you got this block id?

你为每一行获取block_id并在临时表中输入并使用相同的方法来更新你获得此块ID的表的原因是什么？

What is the reason behind you getting the block_id for each row and sotring in temp table and using the same to update the table from which you got this block id?

我想你错过了我的想法，生成了block_id，这就是得到更新的内容。 block_id当时是未知的，它是在使用trans_id更新行之后生成的。喔，感谢快速回复......

You missunderstood me i think, the block_id gets generated and that is what gets updated back. The block_id is not known at that time, it gets generated after the update of the rows with a trans_id. Ow, and thanks for the fast reply...

我想你了解了我，生成了block_id，这就是更新的内容背部。 block_id当时是未知的，它是在使用trans_id更新行之后生成的。喔，感谢快速回复...

You missunderstood me i think, the block_id gets generated and that is what gets updated back. The block_id is not known at that time, it gets generated after the update of the rows with a trans_id. Ow, and thanks for the fast reply...

你正在做的第一次更新是手动完成的吗？

所以你手动更新，以及在该表上触发AFTER UPDATE触发器的COMMIT调用另一个过程来生成block_id吗？

The first update that you are doing is done manually is it?
so you do manual update, and COMMIT which triggers a AFTER UPDATE trigger on that table which calls another procedure to generate block_id?