Oracle 参数 PLSQL_V2_COMPATIBILITY 官方解释，作用，如何配置最优化建议
本站中文解释
PL/SQL v2 Compatibility模式是一种特殊的兼容模式，它允许使用旧版本11.2中引入的新特性。这样，用户可以在新版本中利用已有的PL/SQL代码，而无需进行大量修改。
要正确设置，可以使用ALTER SYSTEM命令将参数值设为TRUE：
ALTER SYSTEM SET PLSQL_V2_COMPATIBILITY = TRUE;
或者，也可以使用对话框中的“Database Configuration Assistant”设置参数值，然后通过“将更改应用到数据库实例”进行更改。
官方英文解释
PLSQL_V2_COMPATIBILITY is used to specify whether abnormal behavior that PL/SQL Version 2 allows will be allowed in PL/SQL Version 8.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
Note:
The PLSQL_V2_COMPATIBILITY parameter is deprecated. It is retained for backward compatibility only.
PL/SQL Version 2 allows some abnormal behavior that Version 8 disallows. If you want to retain that behavior for backward compatibility, set PLSQL_V2_COMPATIBILITY to true. If you set it to false, then PL/SQL Version 8 behavior is enforced and Version 2 behavior is not allowed.
See Also:
Oracle Database PL/SQL
Language Reference for a description of the differences between PL/SQL Version 2 and Version 8, and for more information on setting this parameter
