You can translate the question and the replies:

With Clause/statement

Hi There, Can denodo send WIth Clause Query as it is to Oracle Data source? Why denodo try to optimize With Clause into SubSQL Query? Can we pass direct With Clause to any data source via denodo ? thanks,
Denodo 8 Oracle Optimization
user
08-11-2023 10:59:12 -0500
code

1 Answer

Hi, The WITH clause is defined as being a common table expression (CTE). A CTE is like a temporary result set that is defined and used for the duration of a SQL statement execution. See [here](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/with_clause/with_clause) for an example. As it is a VQL Clause, It can be used in VQL statements to query or create views. Denodo can send statements including the WITH clause to Oracle or to any other Database Management System that supports it. I have just tried it and it worked fine. Moreover, in Denodo Design Studio, you could use the Create from query option (which is used for creating Base Views) to force Denodo to execute a statement in a specific way. Hope this helps.
Denodo Team
09-11-2023 07:40:37 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here