Decent Visual SQL query Builder

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.

Answer 1

It is not free, but I use pl sql developer

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

Answer 2

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.

Answer 3

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