ORA-01722, ORA-01839, ORA-01841, ORA-01847 or ORA-01858 from Queries with Dependent Predicates
(Doc ID 232243.1)
Last updated on FEBRUARY 12, 2019
Oracle Database - Enterprise Edition - Version 188.8.131.52 and later Oracle Database - Personal Edition - Version 184.108.40.206 and later Oracle Database - Standard Edition - Version 220.127.116.11 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata 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!