Menu
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.
653
Visual SQL query builders provide the ability to code SQL using visual elements. This visual way of building queries attracts SQL veterans and newbies alike as a way to both speed up and simplify the process of querying data. But not all visual SQL builders are made equally.
SQL will not be replaced for a long time, as it has a number of key benefits: It is very popular among data professionals. Leading tech companies rely on relational databases and SQL. Professionals working with data are used to SQL; it's quite challenging to re-train the workforce to use another tool.
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.
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
