5

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.

kurast
  • 1,660
  • 3
  • 17
  • 38
  • 1
    You're a coder who needs visual aids? – Emyr Dec 03 '09 at 16:45
  • 1
    It's very possible he's never worked extensively with a declaritive, set-based language like SQL. Some people learn visually. – phoebus Dec 03 '09 at 16:48
  • @Emyr Developing and writing SQL Scripts are two different things :D. – Andrew Dec 03 '09 at 16:49
  • 1
    I cannot unit test individual pieces of a SQL query, because, sometimes, the minimal SQL Select I need to return what I want is 200 lines long. I think visually some of this complexity will fade away. – kurast Dec 03 '09 at 16:53
  • 1
    @Emyr, when I have to create or debug huge queries, I draw a chart... i f I can have the tools to do it automatically I will be happy... and more productive too. What you said is like: who needs and IDE with refactoring tools... – Guillaume May 12 '11 at 08:51
  • My point was more about the aptitudes expected in someone who choses to be and describe themselves as a coder. If you find LINQ easier to use, you could try LINQPad (paid for, so you get Intellisense) so you can more easily wrangle your data, then let it generate the SQL for you. See http://stackoverflow.com/questions/30790/is-there-a-way-to-use-linq-to-oracle#32467 for Linq-to-oracle... – Emyr May 12 '11 at 10:01

5 Answers5

6

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.

Pop
  • 3,932
  • 1
  • 17
  • 12
1

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

Zsolt Botykai
  • 50,406
  • 14
  • 85
  • 110
Alvin
  • 37
  • 1
1

It is not free, but I use pl sql developer

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

JayG
  • 612
  • 1
  • 6
  • 11
1

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

salman aziz
  • 11
  • 1
1

Try SQLeo Visual Query Builder

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

It permits to join tables visually

Brian Webster
  • 30,033
  • 48
  • 152
  • 225
PAscal
  • 11
  • 1