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.

image

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.