# Oracle Database Query

**URL:** <https://forum.uipath.com/t/oracle-database-query/295729>\
**Category:** Studio\
**Tags:** oracle, question, studio, database, activities\
**Created:** [March 4, 2021, 2:10pm UTC](https://forum.uipath.com/t/oracle-database-query/295729 "2021-03-04T14:10:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![eperes](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/eperes/32/19267_2.png) [@eperes](https://forum.uipath.com/u/eperes)\
**Post date:** [March 4, 2021, 2:10pm UTC](https://forum.uipath.com/t/oracle-database-query/295729/1 "2021-03-04T14:10:04Z")

</div>

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.

 ![Capturar](https://global.discourse-cdn.com/uipath/original/3X/5/e/5e333ca64e1a99d05ca165a8d49c08c1d15a3c9e.jpeg)

 ![image](https://global.discourse-cdn.com/uipath/original/3X/f/a/fa8c33555ca1c0a9603b6fcc2e939a0832ea9ab7.png)

When the query starts with “Select…” the data is returned successfully.

 ![image](https://global.discourse-cdn.com/uipath/original/3X/6/5/65d1a2ae599837ff124d9226a0e016e571b61aa8.png)

I would like to use the clause “With As” for performance reasons.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![Adityan](https://avatars.discourse-cdn.com/v4/letter/a/0ea827/32.png) [@Adityan](https://forum.uipath.com/u/Adityan)\
**Post date:** [March 4, 2021, 6:15pm UTC](https://forum.uipath.com/t/oracle-database-query/295729/2 "2021-03-04T18:15:57Z")

</div>

Try using execute Non query activity for with as.

---

<div class="post-metadata">

**Author:** ![karthikui](https://avatars.discourse-cdn.com/v4/letter/k/3da27b/32.png) [@karthikui](https://forum.uipath.com/u/karthikui)\
**Post date:** [May 4, 2021, 8:28am UTC](https://forum.uipath.com/t/oracle-database-query/295729/3 "2021-05-04T08:28:41Z")

</div>

Help me to connect Oracle DB 12c in UI path