Decent Visual SQL query Builder [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. 开发者_Go百科

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

I am a code developer, not a DBA, and I tend to get lost with loooong SQL queries, when I use many joins (10 joins is pretty common for me).

I would like to find a Visual SQL Query Builder (free if possible) that could connect to Oracle and see all the tables there, so I would only select visually my keys that link the Joins, and select the fields I want to be shown.

---

Oracle's own SQL Developer (free to download Java app) has a visual query builder (I haven't used it though, so this is not a recommendation, merely an FYI).

More about Oracle SQL Developer (and download link) here.

---

It is not free, but I use pl sql developer

http://www.allroundautomations.com/plsqldev.html

---

use Visual Studio Server Explorer to connect to oracle and then build queries using query builder.

---

Try Insight Developer for Oracle, but note that it is not free. I use it on both Mac and Linux.

---

Try SQLeo Visual Query Builder

http://sourceforge.net/projects/sqleo/

It permits to join tables visually