english deutsch
Developer Tools
Bear Claw, Benthic Software, CAST SQL-Builder, ClearSQL by Nordic Tree Software, DBPartner for Oracle, dbSaint, DreamCoder for Oracle, Embarcadero Technologies, Isidian SQL Insight, JDBExplorer
more
Backus-Naur notation for PL/SQL
http://cui.unige.ch/db-research/Enseignement/analyseinfo/PLSQL21/BNFindex.html
BNF for PL/SQL 2.1 for Oracle7 (an old version, but still interesting)
Code Samples and Suggestions
http://www.jlcomp.demon.co.uk/ind_plsql.html
Over a dozen tips, tricks, and code samples, by Jonathan Lewis.
FAQ by Frank Naudé
http://www.orafaq.com/faqplsql.htm
Part of the so-called "underground" Oracle FAQ, this is a brief but useful list of PL/SQL questions & answers.
High Speed PLSQL
http://home.earthlink.net/~rodger22/plsql.htm
NOUG presentation on High Speed PLSQL Tuning by Rodger Lepinsky.
ITToolbox - PL/SQL code exchange
http://oracle.ittoolbox.com/code/d.asp?i=10&t=430&a=t
Public forum where programmers can submit, retrieve, and rate PL/SQL code fragments
Ixora Q & A
http://www.ixora.com.au/q+a/plsql.htm
Questions with answers by Steve Adams, expert on Oracle internals
Message board on orafaq.net
http://www.orafaq.net/msgboard/plsql/index1.htm
Unmoderated questions and answers.
mod_owa: Apache PL/SQL Gateway Module
http://www.sharemation.com/~dmcmahon/modowa.htm
Open source Apache module allowing PL/SQL to generate dynamic web pages.
mod_plsql
http://www.total-knowledge.com/progs/mod_plsql/
A Apache module. It aims to provide Oracle Web Application Server 3.0 API compatible interface to Oracle RDBMS. Tested with Oracle8/8i.
Oracle Larry Bot
http://www.billboard.net/oraclelarrybot.htm
An artifical intelligent agent who can be queried for Oracle Error Messages. He is currently accessible via AOL IM.
Oracle Technology Network: PL/SQL
http://technet.oracle.com/tech/pl_sql/
Official product documentation, white papers, technical briefs, feature lists.
OracleTricks - Tips, Tricks, and Utilities
http://www.geocities.com/oracletricks/plsql/
Free, reusable PL/SQL scripts; page is part of larger collection of Oracle tricks.
PL/SQL help and tutorial
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm
Simple examples of various language features
PL/SQL tips
http://www.oracledba.co.uk/tips_plsql.htm
Short tips and code fragments written (or collected) by Connor McDonald. Includes bit operations, undocumented features, and 8.1.7.
PL/SQL Tutorials
http://www.hot-oracle.com/topics.html?topicId=2
Ian Saunder's introductory lessons on PL/SQL.
PLNet.org
http://plnet.org/
An open source, focused, common repository for PL/SQL developers. Intended to improve the day-to-day life of thousands of Oracle developers around the world.
RevealNet PL/SQL Tips
http://www.revealnet.com/pipelines/plsql/tips.htm
PL/SQL Tip of the Month and archives.
Selected Utilities/Frequently Asked Questions
http://govt.oracle.com/~tkyte/
Scripts and solutions from Oracle maven Thomas Kyte, including a PL/SQL generator to address the "update cascade" problem.
UC Davis - Tutorials
http://sirius.cs.ucdavis.edu/teaching/sqltutorial/
Oracle SQL and PL/SQL tutorials from the UC Davis Database and Information Systems Group (DBIS)
utPLSQL Project
http://oracle.oreilly.com/utplsql/
Open-source unit testing framework based on principles of "Extreme Programming."