ORA-40119: nested columns incompatible with missing value treatment

文档解释

ORA-40119: nested columns incompatible with missing value treatment

Cause: delete_row missing value treatment is not supported for nested columns.

Action: Use 2D (non-nested) data representation or manually delete the rows with NULL values and disable the delete_row missing value treatment.

ORA-40119: 嵌套列与缺失值处理不兼容

官方解释

常见案例

DELETE FROM table

WHERE column_name IS NULL;

一般处理方法及步骤

1.如果删除缺失值,那么嵌套列也就要被删除,所以应该改用其他填充技术;

2.可以使用空字符串来替换空值;

3.改为在外部嵌套查询中过滤空值;

4.使用列表函数(如case()、nvvl())将空值替换为非空值;

5.在Oracle 18c之后的版本引入了特殊处理,可以使用delete_at_null拓展新选项。

你可能感兴趣的