<p>There are many options for editing and writing Stored Procedures in Oracle; what is the best tool for you and why? (one tool per answer.)</p>

[{'answer_id': 69774, 'author': 'Allan Wind', 'author_id': 9706, 'author_profile': 'https://Stackoverflow.com/users/9706', 'pm_score': 0, 'selected': False, 'text': '<p>I just used a standard editor (vim which then gave me syntax highlighting).</p>\n\n<p>/Allan</p>\n'}, {'answer_id': 69782, 'author': 'fuentesjr', 'author_id': 10708, 'author_profile': 'https://Stackoverflow.com/users/10708', 'pm_score': 0, 'selected': False, 'text': '<p>I like <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow noreferrer">SQL Developer</a> from Oracle. Oh and its free! :)</p>\n'}, {'answer_id': 69789, 'author': 'Chris Kimpton', 'author_id': 48310, 'author_profile': 'https://Stackoverflow.com/users/48310', 'pm_score': 0, 'selected': False, 'text': '<p>I like <a href="http://www.embarcadero.com/products/rapidsql/index.html" rel="nofollow noreferrer">Rapid SQL</a>, you can debug SQL too</p>\n'}, {'answer_id': 69792, 'author': 'arturh', 'author_id': 4186, 'author_profile': 'https://Stackoverflow.com/users/4186', 'pm_score': 3, 'selected': False, 'text': '<p>I recently found the free <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow noreferrer">Oracle SQL Developer</a>.</p>\n\n<ul>\n<li>nice looking GUI (makes you not poke out your eyes like the usual Oracle tools)</li>\n<li>has many nice features, like showing tables filtered </li>\n<li>lets you connect to multiple oracle instances at once</li>\n<li>you can use sane configuration like ip:port username/password and do not have to use those strange TNSNAMES.ORA file based settings</li>\n<li>you can set breakpoints and step through the code of stored procedures.</li>\n</ul>\n'}, {'answer_id': 69794, 'author': 'Chris Kimpton', 'author_id': 48310, 'author_profile': 'https://Stackoverflow.com/users/48310', 'pm_score': 1, 'selected': False, 'text': '<p>But some at our place swear by <a href="http://www.toadsoft.com/" rel="nofollow noreferrer">Toad</a></p>\n'}, {'answer_id': 69800, 'author': 'Johan Danforth', 'author_id': 6415, 'author_profile': 'https://Stackoverflow.com/users/6415', 'pm_score': 2, 'selected': False, 'text': '<p>Toad, from ToadSoft.com -> <a href="http://www.toadsoft.com/toad_oracle.htm" rel="nofollow noreferrer">http://www.toadsoft.com/toad_oracle.htm</a></p>\n\n<p>For someone like me who likes to work with a DBA tool like Microsoft\'s SQL Management Studio, it\'s a life saver.</p>\n'}, {'answer_id': 69876, 'author': 'Andrew', 'author_id': 5662, 'author_profile': 'https://Stackoverflow.com/users/5662', 'pm_score': 4, 'selected': False, 'text': '<p><a href="http://www.toadsoft.com/lic_agree.html" rel="nofollow noreferrer"><strong>T</strong>ool for <strong>O</strong>racle <strong>A</strong>pplication <strong>D</strong>evelopers (TOAD)</a>, from <a href="http://www.quest.com/" rel="nofollow noreferrer">Quest Software</a> (formerly <a href="http://www.toadsoft.com/" rel="nofollow noreferrer">TOADSoft</a>) has an excellent Stored Procedure editor with syntax highlighting, some autocomplete support (e.g. type in \'<code>TABLE.</code>\' and the columns will appear), a nice Execute Procedure option that will show the results in a Grid or show DBMS output, and will also focus on syntax errors when you hit compile.</p>\n\n<p><em>Note:</em> The Freeware edition only allows 2 concurrent connections to the same Database Instance (even though the website says 5) - that means only 2 developers or DBA\'s can use it at the same time on the same Database. It also expires every 3 months but they\'re good at releasing updates.</p>\n'}, {'answer_id': 69886, 'author': 'Sébastien D.', 'author_id': 833, 'author_profile': 'https://Stackoverflow.com/users/833', 'pm_score': 0, 'selected': False, 'text': '<p>Notepad++ stays my favourite editor. I had to use SQL Developer in the past, it\'s not so "bad", but I encountered many problems with it. It proved very unstable so I wouldn\'t recommend it, or maybe only to test your procedures.</p>\n'}, {'answer_id': 70726, 'author': 'Rob Paterson', 'author_id': 11571, 'author_profile': 'https://Stackoverflow.com/users/11571', 'pm_score': 0, 'selected': False, 'text': "<p>I use JetBrains IDEA (a Java IDE) to edit and SQL*Plus to execute. The advantages of using a tool with local version control, seemless integration into Source Version Control, advanced find and highlighting, great editing, 'live templates' and so on for me outweighs any advantage of having it 'database aware' (which with plug-ins you can get anyway). If I was coding up a complicated query I might fire up SQL Developer, but generally I prefer great text editing features.</p>\n"}, {'answer_id': 71484, 'author': 'John_D', 'author_id': 8891, 'author_profile': 'https://Stackoverflow.com/users/8891', 'pm_score': 2, 'selected': False, 'text': '<p>PL/SQL Developer from Allaround Automations.<p> \nI happily paid the $200 or so price for this.<p></p>\n\n<p>Excellent IDE (+ good Intellisense, + debugging capability) with easy creation and editing of PL/SQL packages, SPs, Triggers etc</p>\n\n<p>So much better than Toad.</p>\n'}, {'answer_id': 71714, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 2, 'selected': False, 'text': "<p>As a professional PL/SQL developer I use (heh) PL/SQL Developer from Allaround Automations.\nI've worked with TOAD for quite a long time but now it is quite overpriced comparing with PL/SQL dev. It has some advantages like knowledge base or ability to work with other RDBMS like SQL server but that's not a necessity for me.</p>\n\n<p>But Notepad++ will always help to make occasional fix. </p>\n"}, {'answer_id': 71729, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>I use Oracle SQL Developer - the latest version also has support for CVS and Subversion.</p>\n\n<p>It has the bonus of supporting other database providers, too.</p>\n\n<p>I have used this tool for 2 years and it has now settled down to be reliable.</p>\n'}, {'answer_id': 71823, 'author': 'Mike Desjardins', 'author_id': 10466, 'author_profile': 'https://Stackoverflow.com/users/10466', 'pm_score': 0, 'selected': False, 'text': "<p>I've used RapidSQL by Embarcadero on several different DB platforms, and it's awesome.  It has an integrated step debugger, too.  I haven't actually used it with Oracle, but I know it's supported.</p>\n"}, {'answer_id': 71883, 'author': 'CJM', 'author_id': 6898, 'author_profile': 'https://Stackoverflow.com/users/6898', 'pm_score': 0, 'selected': False, 'text': "<p>Another vote for Oracle SQL Developer. It's free, it's stable and it does all the basics that I require.</p>\n"}, {'answer_id': 72124, 'author': 'dummy', 'author_id': 6297, 'author_profile': 'https://Stackoverflow.com/users/6297', 'pm_score': 0, 'selected': False, 'text': '<p>With the mentioned SQL Developer you can even set breakpoints and step through the code of the stored procedure.</p>\n'}, {'answer_id': 78225, 'author': 'user14308', 'author_id': 14308, 'author_profile': 'https://Stackoverflow.com/users/14308', 'pm_score': 0, 'selected': False, 'text': '<p>Yet another vote for Oracle SQl Developer. But TOAD works too.</p>\n'}, {'answer_id': 78807, 'author': 'ropable', 'author_id': 14508, 'author_profile': 'https://Stackoverflow.com/users/14508', 'pm_score': 1, 'selected': False, 'text': '<p>Use Oracle\'s own <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow noreferrer">SQL Developer</a>. If you are mainly working with Oracle, it does everything you\'ll need.</p>\n'}, {'answer_id': 79011, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 1, 'selected': False, 'text': "<p>I use TOAD with our Oracle reports development, and I think that it's a good development tool. I normally toggle back and forth between a number of different Oracle instances and schemae, and I like the way that TOAD can display multiple windows for each instance/schema, or even more than one per schema. </p>\n\n<p>TOAD takes a little while to learn and customize, but it's a worthwhile investment. The layout is similar to the Visual Studio .NET IDE with sidebars that can be anchored or rolled away. Tabs display different aspects of the Oracle schema, including procedures, jobs, stats, etc. And when I'm writing SQL, the editor uses color-coding and the error messages are Oracle-specific.</p>\n"}, {'answer_id': 80701, 'author': 'Andrew', 'author_id': 5662, 'author_profile': 'https://Stackoverflow.com/users/5662', 'pm_score': 1, 'selected': False, 'text': '<p><a href="http://tora.sourceforge.net/" rel="nofollow noreferrer"><strong>T</strong>oolset for <strong>Ora</strong>cle (TOra)</a> is a free, Open Source Database Tool very similar in scope (and look and feel) to <a href="http://www.toadsoft.com/lic_agree.html" rel="nofollow noreferrer">Quest\'s TOAD</a></p>\n\n<p>Compared to the <a href="http://www.toadsoft.com/lic_agree.html" rel="nofollow noreferrer">freeware edition of TOAD</a>, TOra allows multiple connections to different database instances at the same time, and has no concurrent connection limit (so any number of TOra users can be working on the same database instance)</p>\n'}, {'answer_id': 85578, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>A really good text editor with syntax highlighting (e.g. Textpad from www.textpad.com) and SQL Plus.</p>\n'}, {'answer_id': 981882, 'author': 'Kuberchaun', 'author_id': 102388, 'author_profile': 'https://Stackoverflow.com/users/102388', 'pm_score': 2, 'selected': False, 'text': '<p>I always use PL/SQL Developer from Allround Automations.</p>\n\n<p><a href="http://www.allroundautomations.com/plsqldev.html" rel="nofollow noreferrer">http://www.allroundautomations.com/plsqldev.html</a></p>\n'}, {'answer_id': 1409535, 'author': 'Cshah', 'author_id': 74098, 'author_profile': 'https://Stackoverflow.com/users/74098', 'pm_score': 0, 'selected': False, 'text': '<p>For me its, Oracle SQL Developer. The learning curve is very minimal if you have worked on IDEs like Eclipse or VS. You can set break points, read live values when you debug stored procs as you would do to code in eclipse/VS.\nOfcourse the UI is a bit sluggish at times but given that its free compensates the sluggishness.</p>\n'}, {'answer_id': 3408999, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': "<p>I use Textpad, Clipmate and Quest SQLNavigator. The newer versions of Quest's SQLNavigator  and TOAD are crap -- they tend to crash easily and don't play nice with XP/Vista/Win7.  </p>\n\n<p>I've spent hours with their tech support and they don't have alternatives.<br>\nYou get no access to Quest programmers, but rather you get bogged down in their<br>\ntrouble ticket process.  </p>\n\n<p>Quest needs to focus less on integration of different tools into one and selling you<br>\npromises that the next version will solve the instability issues.  </p>\n\n<p>They need stability.<br>\nThis means cleaning up their existing codebase or starting over.<br>\nMore competent programmers, fewer salespeople, fewer tech support people.<br>\nFix the damn problems.<br>\nThey focus on sales and it's an idiotic business strategy.<br>\nThis seems to be a problem across the industry.  </p>\n\n<p>Quest's TOAD and SQL Navigator have become bloatware and will soon become abandonware<br>\nif they don't turn them around and make them more stable.  </p>\n\n<p>I copy and paste frequently between Textpad and Quest SQLNavigator because SQLNavigator<br>\ncrashes and I lose all my sql code up to the point of crash.  </p>\n\n<p>I'll probably dump SQLNavigator once I find something more stable.</p>\n"}, {'answer_id': 4140879, 'author': 'geekzspot', 'author_id': 262282, 'author_profile': 'https://Stackoverflow.com/users/262282', 'pm_score': 0, 'selected': False, 'text': "<p><strong>SQL Developer from Oracle</strong></p>\n\n<p>We have replaced all other tools at our (large well known) enterprise that has over 150 databases and it works just fine. It's not as good as TOAD but it is getting there, and (unlike TOAD) <strong>it's free</strong>.</p>\n\n<p>SQL Developer also works well enough connecting to SQL Server</p>\n"}]
['https://Stackoverflow.com/questions/69764', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4491/']