Oracle SQL Developer has disadvantages, such as the inability to execute or debug a query in a stored procedure, which is something we had in TOAD, a licensed tool with a richer feature set. So, we're dealing with the limitations of Oracle SQL Developer. Other than the debugging feature, I wish Oracle SQL Developer had better connectivity similar to TOAD, where we could simply input the DNS name without repeatedly entering passwords. Although there is a save option in Oracle SQL Developer, TOAD had a more developer-friendly interface, which I miss. The debugging functionality was much more convenient and smooth in TOAD compared to Oracle SQL Developer. I find Oracle SQL Developer less interactive and less developer-friendly, particularly when it comes to debugging, which was easier in TOAD.
