Directory of PL-SQL Resources

Home > Computers > Programming > Languages > PL-SQL

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 used in several of Oracle's client-side application development tools.

Subcategories

• Developer Tools

Resources in This Category

• BNF Index of PL/SQL Version 2.1 for Oracle 7

  http://cui.unige.ch/db-research/Enseignement/analyseinfo/PLSQL21/BNFindex.html
  Backus-Naur Notation for PL/SQL 2.1 for Oracle 7. 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.

• High Speed PLSQL

  http://home.earthlink.net/~rodger22/plsql.htm
  NOUG presentation on High Speed PLSQL Tuning by Rodger Lepinsky.

• 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.com/forum/
  Unmoderated questions and answers.

• mod plsql

  http://www.total-knowledge.com/progs/mod_plsql/
  An Apache module. It aims to provide Oracle Web Application Server 3.0 API compatible interface to Oracle RDBMS. Tested with Oracle8/8i.

• Oracle Technology Network: PL/SQL

  http://www.oracle.com/technetwork/database/features/plsql/index.html
  Official product documentation, white papers, technical briefs, feature lists.

• PL/SQL FAQ

  http://www.orafaq.com/wiki/PL/SQL_FAQ
  Part of the Oracle FAQs, this is a brief but useful list of PL/SQL questions and answers.

• 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.

• PLNet.org

  http://www.datacraft.com/plnet/
  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.

• Wikipedia: PL/SQL

  http://en.wikipedia.org/wiki/PL/SQL
  Encyclopedia article about the Oracle extension to SQL, including an overview of its functionality, data types, and constructs.

Related Categories

• Home > Computers > Programming > Internet > Databases
• Home > Computers > Programming > Languages > Comparison and Review
• Home > Computers > Programming > Languages > Database
• Home > Computers > Programming > Languages > Interpreted > Procedural
• Home > Computers > Programming > Languages > Procedural
• Home > Computers > Programming > Languages > SQL
• Home > Computers > Software > Databases > Oracle

 

Home > Computers > Programming > Languages > PL-SQL

 

---

 

Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web. About us