Database Answers

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
  Oracle PL/SQL Development
 

PL/SQL is Oracle's proprietary extension to SQL.
This Page identifies some of the options available if you are developing PL/SQL-based applications
Here's a short description :-
1) Use vi or JEdit and sqlplus for all your PL/SQL development, and it should work out just fine.
2) For something graphical, check out Toad or its open-source clone, Tora.
3) SQL Navigator which offers productivity gains of at least 20-50 times more than manual PL/SQL editor.
4) JDeveloper is (perhaps surprisingly) very good for PL/SQL development.
5) An interesting option is Oracle's new release of Apex, whch is built on PL/SQL, and generates the html pages directly from MetaData stored in the database.

We are very keen to hear from anyone willing to share their experience.

USEFUL LINKS FOR PL/SQL
CATEGORY NAME PRICE SOURCE COMMENTS
Debugger PL/SQL Trace $20 Material Dreams "Overcomes the limitations of DBMS_OUTPUT."
Development Alligator SQL   Alligator Also offers DBA facilities for a range of DBMSs.
Development dbForge Studio for Oracle $0-$399.95 Devart A powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.
Development DreamCoder $105 Mentat Another IDE for PL/SQL.
Development Dynamic PSP $99.95 Share*It Automates the production of PL/SQL Server Pages,(PSPs)
Development HTMLDB Free From Oracle Technology Network An interesting approach to building Internet Applications with MetaData stored in an Oracle Database.
Development IDS - Oracle Internet Developer Suite - requires (free) Registration.
Development JDeveloper - Oracle Technology Network Requires (free) Registration.
Development JEdit & SQL*Plus Free Open Source and Oracle ! An interesting combination which comes higly recommended.
Development KeepTool $560 KeepTool  
Development PL/SQL Developer $150 AllroundAutomation Recommended
Development Rapid SQL $895.00 Embarcadero
Development SQL Navigator $795 Quest Looks good but expensive unless someone else is paying the bill.
Development SQL*Plus and JEdit Free Open Source and Oracle ! An interesting combination which comes higly recommended.
Development SQL Station - Computer Associates (CA) Free download available.
Development Toad $670 Quest Product of choice for corporates.
Development Tora - GlobeCom (Sweden) "Better than TOAD" - Open Source for Linux/UNIX.
 
Documentation PL DOC Free !!! SourceForge "Open Source Utility for generating PL/SQL code documentation, analagous to JavaDoc for Java".
Editor PL/SQL Editor Free !!! Alchemy Download file is only 157Kb so functionality may be limited.
Editor PL/SQL Editor $150 AllRoundAutomations Free download evaluation copy available.
Editor PLEdit $35 Benthic Free download evaluation copy available.
Editor OraEdit Pro $99 DKG Looks good (includes a Table Browser !) and is very affordable.
Editor PL/SQL Editor $150 InThink Free download evaluation copy available
Offers an interesting range of other products - especially for Delphi.
Editor PL/SQL Editor - Oracle Technet Free if you are an Oracle customer.
Library PL/Crypt - Semantica "Provides Encryption facilities."
Library PL/File - Semantica "Offers advanced remote file functionality."
Library PL/Run - Semantica "Advanced Process and Job Functionality"
Library PL Vision - RevealNet Looks very useful. and developed by Steve Feuerstein.
Testing utPL/SQL - Steve Feuerstein Seems to be in a class of its own - from a highly respected writer on PL/SQL.

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map