Oracle Database Query

Hello everyone,

I’m doing a query in the Oracle Database, however when I start this query with the “With As…” clause I have no data return.


When the query starts with “Select…” the data is returned successfully.

I would like to use the clause “With As” for performance reasons.

Any suggestions?

Try using execute Non query activity for with as.

Help me to connect Oracle DB 12c in UI path