| Oracle变异表错误解决方案选择 |
| |
| 引用本文： | 彭彬,齐心.Oracle变异表错误解决方案选择[J].湖北汽车工业学院学报,2013(4):49-52. |
| |
| 作者姓名： | 彭彬 齐心 |
| |
| 作者单位： | 湖北汽车工业学院电气与信息工程学院,湖北十堰442002 |
| |
| 摘 要： | Oracle行级触发器应用中常遇到变异表错误,急需一个高性能的解决方案。概述Oracle DML触发器的特点,给出变异表错误出现的场景,分析出现错误的原因,提出分别基于包变量、临时表或复合触发器的3种解决方案,大规模数据测试表明:基于复合触发器的解决方案性能最好。
|
| 关 键 词： | 触发器 变异表 包变量 临时表 自治事务 |
Choice of Solutions to Oracle Mutating Table Error |
| |
| Peng Bin,Qi Xin.Choice of Solutions to Oracle Mutating Table Error[J].Journal of Hubei Automotive Industries Institute,2013(4):49-52. |
| |
| Authors: | Peng Bin Qi Xin |
| |
| Institution: | (School of Electrical ＆ Information Engineering, Hubei University of Automotive Technology, Shiyan 442002, China) |
| |
| Abstract: | A mutating table error is often encountered in the Oracle row trigger application, so a high performance solution to the problem is needed. The characteristic of Oracle DML trigger was summarized, the scene of the mutating table error was given, and the reason for the error was analyzed. Three solutions based on the package variable, temporary table or compound trigger were proposed, a large-scale data testing indicates that the performance of the solution based on the compound DML trigger is best. |
| |
| Keywords: | trigger mutating table package variable temporary table autonomous transaction |
| 本文献已被 维普 等数据库收录！ |
|
