主动脉 发表于 2025-3-26 21:19:18
http://reply.papertrans.cn/32/3192/319156/319156_31.png他很灵活 发表于 2025-3-27 03:59:02
http://reply.papertrans.cn/32/3192/319156/319156_32.pngHost142 发表于 2025-3-27 08:10:58
Autonomous Transactions,We have seen how they can be used to do things that have previously not been possible, such as performing DDL in a trigger or running any stored function via a SELECT statement, regardless of whether that function wrote to the database or not. We also saw that it is not wise to think you know exactlfaction 发表于 2025-3-27 12:19:35
Dynamic SQL, when to use one over the other. Both implementations have their time and place. Dynamic SQL allows you to write procedures that are otherwise impossible - generic utilities to dump data, to load data, and so on. Further examples of dynamic SQL-based routines can be found on the Apress web site, sucFIN 发表于 2025-3-27 15:26:18
http://reply.papertrans.cn/32/3192/319156/319156_35.pngcavity 发表于 2025-3-27 18:23:49
https://doi.org/10.1007/978-3-662-25521-6ailable for you to use in your applications as well. A thorough understanding of transactions, how they work, where they start, and when they end, is mandatory before utilizing this feature, as various side effects can occur. For example, a session can deadlock itself, a parent transaction may or maDALLY 发表于 2025-3-28 01:24:47
http://reply.papertrans.cn/32/3192/319156/319156_37.png完成 发表于 2025-3-28 03:34:29
http://reply.papertrans.cn/32/3192/319156/319156_38.pngordain 发表于 2025-3-28 10:19:04
http://reply.papertrans.cn/32/3192/319156/319156_39.png