ORA-01722, ORA-01839, ORA-01841, ORA-01847 or ORA-01858 from Queries with Dependent Predicates
(Doc ID 232243.1)
Last updated on NOVEMBER 12, 2020
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later Oracle Database - Personal Edition - Version 188.8.131.52 and later Oracle Database - Standard Edition - Version 184.108.40.206 and later Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform.
To explain the possible causes of these errors in SQL statements that include predicates that are dependent on each other.
DBA's, architects, developers, Support analysts
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!