Analysis of Methods for Solving Error Reporting ora-32035

Ora-32035 error reported
If the with clause is defined and is not used in a query, A ora-32035 error is reported: the query name defined in the with clause is not referenced. (At least one with query name is not referenced. The solution is to remove the with query that is not referenced ),Note:As long as there is a reference behind it, it is not necessary to reference it in the primary query. For example, it is also possible to reference it in the with query.

Example:
Copy codeThe Code is as follows:
With q1 as (select 0 + 1 num1 from dual), q2 as (select 1 + 1 num2 from dual), q3 as (select 2 + 1 num3 from dual)
Select * from q1
Union
Select * from q3
Union
Select * from q2;

When q1, q2, and q3 are defined, they must be referenced later, not necessarily in the primary query.