Oracle Database Query

[eperes (Erick Marques Peres)]

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?

[Adityan]

Try using execute Non query activity for with as.

[karthikui (Karthik)]

Help me to connect Oracle DB 12c in UI path