Is there a possible way to execute sql in QTP using 'WITH' clause

[shruthic]

I've connected to Oracle Database using qtp and I am trying to execute a statement using 'WITH' clause in the query, but I am unable to achieve the same.

Code:

Sample query : WITH VIEW123 AS (SELECT * FROM ) SELECT * FROM VIEW123

Note: The above mentioned query is just an example. I am using the with clause, since I would be using the query inside the view123 in multiple areas in the query. Would appreciate any solution provided.