 |
Selected Utilities/Frequently Asked Questions
Scripts and solutions from Oracle maven Thomas Kyte, including a PL/SQL generator to address the "update cascade" problem.
http://govt.oracle.com/~tkyte/ |
 |
UC Davis - Tutorials
Oracle SQL and PL/SQL tutorials from the UC Davis Database and Information Systems Group (DBIS)
http://sirius.cs.ucdavis.edu/teaching/sqltutorial/ |
 |
Message board on orafaq.net
Unmoderated questions and answers.
http://www.orafaq.net/msgboard/plsql/index1.htm |
 |
FAQ by Frank Naudé
Part of the so-called "underground" Oracle FAQ, this is a brief but useful list of PL/SQL questions & answers.
http://www.orafaq.com/faqplsql.htm |
 |
utPLSQL Project
Open-source unit testing framework based on principles of "Extreme Programming."
http://oracle.oreilly.com/utplsql/ |
 |
Code Samples and Suggestions
Over a dozen tips, tricks, and code samples, by Jonathan Lewis.
http://www.jlcomp.demon.co.uk/ind_plsql.html |
 |
Oracle Larry Bot
An artifical intelligent agent who can be queried for Oracle Error Messages. He is currently accessible via AOL IM.
http://www.billboard.net/oraclelarrybot.htm |
 |
Ixora Q & A
Questions with answers by Steve Adams, expert on Oracle internals
http://www.ixora.com.au/q+a/plsql.htm |
 |
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.
http://plnet.org/ |
 |
PL/SQL help and tutorial
Simple examples of various language features
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm |
 |
Oracle Technology Network: PL/SQL
Official product documentation, white papers, technical briefs, feature lists.
http://technet.oracle.com/tech/pl_sql/ |
 |
Backus-Naur notation for PL/SQL
BNF for PL/SQL 2.1 for Oracle7 (an old version, but still interesting)
http://cui.unige.ch/db-research/Enseignement/analyseinfo/PLSQL21/BNFindex.html |
 |
High Speed PLSQL
NOUG presentation on High Speed PLSQL Tuning by Rodger Lepinsky.
http://home.earthlink.net/~rodger22/plsql.htm |
 |
RevealNet PL/SQL Tips
PL/SQL Tip of the Month and archives.
http://www.revealnet.com/pipelines/plsql/tips.htm |
 |
ITToolbox - PL/SQL code exchange
Public forum where programmers can submit, retrieve, and rate PL/SQL code fragments
http://oracle.ittoolbox.com/code/d.asp?i=10&t=430&a=t |
 |
mod_owa: Apache PL/SQL Gateway Module
Open source Apache module allowing PL/SQL to generate dynamic web pages.
http://www.sharemation.com/~dmcmahon/modowa.htm |
 |
PL/SQL Tutorials
Ian Saunder's introductory lessons on PL/SQL.
http://www.hot-oracle.com/topics.html?topicId=2 |
 |
OracleTricks - Tips, Tricks, and Utilities
Free, reusable PL/SQL scripts; page is part of larger collection of Oracle tricks.
http://www.geocities.com/oracletricks/plsql/ |
 |
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.
http://www.total-knowledge.com/progs/mod_plsql/ |
 |
PL/SQL tips
Short tips and code fragments written (or collected) by Connor McDonald. Includes bit operations, undocumented features, and 8.1.7.
http://www.oracledba.co.uk/tips_plsql.htm |
Additional
Information: PL/SQL is Oracle Corporation's proprietary language for writing database event triggers and stored procedures. It is a procedural, interpreted, block-structured language based very loosely on Ada but having very tight integration with SQL. PL/SQL is also
-
