I was caught off guard in a class becausethis feature that needed additional setup. SQL Developer’s debugger in Oracle12 needs some additional permissions to run. SQL Developer doesn’t have anything like this.īoth tools have a similar PL/SQL debugger. Click here to read my blog on Code Analysis. Team leads can quickly see the complexity of the code and make sure the correct people are assigned to a coding project. Developers can see how they did with both complexity of the PL/SQL and SQL code. Toad contains Code Analysis, a nice review using industry standard rules to view PL/SQL code complexity, complexity of the SQL inside the PL/SQL routines, and quality of the PL/SQL code in general. SQL Developer Code Templates/Auto Replace Both tools have good coverage of SQL and PL/SQL topics, including optimizer hints that I use from time to time when doing SQL tuning. Toad has a considerable bit more in both the code template area and the auto replace area. Both allow for coding shortcuts, with SQL Developer using its Code Template setup and Toad usingits Auto Replace feature. SQL Developer’s are signaled with their shortcut name and the space bar. Toad’s templates are signaled with a short name and the CTRL + space bar, or just CTRL + space bar to bring up the whole list.
Toad has quite a few more code templates and they can be setup to be quite interactive with substitution variables.
Toad has a more robust code template with just over 40 templates, where SQL Developer has templates as well their code examples are both in SQL Editor Code Template area (fewer than 10 templates and work more like Toad Auto Replace) and has better code templates in its snippets panel, but again not very many of them. Notice the slider bar, there are quite a few more selections than what would fit in this display box. SQL Developer has a separate snippets panel just for Analytical SQL. Both tools have a history of SQL executed.īoth have code snippets panel where you can drag and drop code examples/formats/hints/formatting/more to the editor window. I hope to do so in an objective way.īoth tools have insights…popup of available objects/columns where you can click and add to your SQL. Since I work with both tools in my training business, people often ask me to point out the differences in the two. Hi, This article hopes to compare Toad v13.0 and SQL Developer v18.1 a bit.
0 kommentar(er)
