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

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

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Is there a possible way to execute sql in QTP using 'WITH' clause (/Thread-Is-there-a-possible-way-to-execute-sql-in-QTP-using-WITH-clause)

Is there a possible way to execute sql in QTP using 'WITH' clause - shruthic - 04-26-2014

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.