Toad Data Point has quite a few of these for various other relational databases as well.īoth have code templates that contain code substitution! This is one of the lab exercises in my class as I find this a cool way to set up your own templates for common SQL you might use. SQL Recall is customizable and saves the last 500 SQL statements executed.īoth tools have code snippets…drag-and-drop code assistants for various functions and features of the connected database. Power users can use this feature to find and re-use SQL from the prior day or so. I use this feature a lot when doing performance tuning. In class, I show this and about five additional ways both Toad and Toad Data Point can create SQL without having to type or even know SQL.īoth tools have the SQL recall, a history of executed SQL statements. This popup allows you to select one or more column names using your mouse. This editor has automatic popup column assistants called in-sites. Common Featuresīoth tools are based off of the SQL Editor, now called just the Editor panel. I will expand on this blog post by Mathew Phan, do a bit more feature-by-feature comparison and give my two cents worth on who should be using which product. The versions of each product are not most important, as I cover the major features that both products have in common then will highlight what each of the products does best. This article hopes to compare Toad v13.0 and Toad Data Point v4.3.

Toad data point license cost