1. ORA-01446 错误的含义 ORA-01446 是 Oracle 数据库中的一个错误代码,其含义为:“cannot insert NULL into (列名)”。这个错误通常发生在尝试向一个不允许 NULL 值的列插入 NULL 值时。 2. 可能导致 ORA-01446 错误的原因 列定义不允许 NULL:数据库中某些列被定义为 NOT NULL,即这些列在插入或更新时必...
(1)10.2.0.5之后的版本,可能遇到这个bug: ORA-1445 or ORA-1446 Referencing ROWID from a Viewwith Subquery (文档 ID 1364607.1) (2)Oracle12.0.0的,可能遇到这个bug: Select from AR_LOCATION_VALUES_DFV ErrorsORA-01446: Cannot Select Rowid From, Or Sample, A View With Distinct (文档 ID 980435.1)...
ORA-1445 or ORA-1446 Referencing ROWID from a Viewwith Subquery (文档 ID 1364607.1) (2)Oracle12.0.0的,可能遇到这个bug: Select from AR_LOCATION_VALUES_DFV ErrorsORA-01446: Cannot Select Rowid From, Or Sample, A View With Distinct (文档 ID 980435.1) 但这里明显和我们的情况不符不符合。又仔细...
语句里主查询中用了 * 号，而 * 号包含了rowid，而主查询的数据源是子查询，主查询并不存在rowid，因此出现了ORA-01446错误。解决方法：在子查询中rowid取别名。例：select rownum,rowid id,... ...
ORA-01446: 无法使用distinct, group by 等子句从试图中选择rowid或采样 ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc 把rowid 改个名就可以了 rowid转json时又报错 org.codehaus.jackson.map.JsonMappingException: No serializer found for class java.io.ByteArrayInputStream and no...
ORA-01446 Cloud Applications Cloud Infrastructure On-Premises Applications Middleware Database Engineered Systems Java Systems Operating Environments Virtualization Industry-Specific Applications Architecture Center Tutorials and Labs All Services & Products
ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc. 我正在寻找为什么会发生这种情况并得出以下结论: 您试图创建一个视图,该视图在 SELECT 语句中包含一个 ROWID 以及一个子句,例如 DISTINCT 或 GROUP BY。这是不允许的。参考 这很尴尬,因为视图中的 select 语句没有选择 rowid 并且它...
ORA-01446: 无法使用distinct, group by 等子句从试图中选择rowid或采样 ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc 把rowid 改个名就可以了 rowid转json时又报错 org.codehaus.jackson.map.JsonMappingException: No serializer found for class java.io.ByteArrayInputStream and no...