Top : Computers : Programming : Languages :
PL-SQL
Websites
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.
site exerpt
PLNet.org An Open Source Repository for PL/SQL Developers Submit your own code via email Visit the PLNet project at Sourceforge Internet, web, xml, and the like CodeBrew A framework for PL/SQL Gateway (mod_plsql) developers. Home http sourceforge.net/projects/plcodebrew/ Download http sourceforge.net/project/showfiles.php?group_id=60431 Minimum Oracle Version 9.2.0 FTP PL/SQL implementation of...Over a dozen tips, tricks, and code samples, by Jonathan Lewis.
site exerpt
Index on PL/SQL items (JL Comp) My page on things you can do with PL/SQL and probably some comments about things you shouldn't do with PL/SQL. Back to Home Page. Title Content Last update PL/SQL arrays v7 Turning a PL/SQL array into an SQL statement (in...Official product documentation, white papers, technical briefs, feature lists.
http://technet.oracle.com/tech/pl_sql/
Part of the so-called "underground" Oracle FAQ, this is a brief but useful list of PL/SQL questions & answers.
site exerpt
Oracle FAQ: PL/SQL Java to code procedures and triggers? How can one see if somebody modified any code? How can one search PL/SQL code for a string/key value? How can one keep a history of PL/SQL code changes? How can I protect my...Open-source unit testing framework based on principles of "Extreme Programming."
site exerpt
O'Reilly: The utPLSQL Project L is being developed as open source, consistent with the lightweight development methodology known as Extreme Programming. As a framework, utPLSQL defines a process and offers a set of packages that PL/SQL developers can use to unit-test their code more...Open source Apache module allowing PL/SQL to generate dynamic web pages.
http://www.sharemation.com/~dmcmahon/modowa.htm
Ian Saunder's introductory lessons on PL/SQL.
http://www.hot-oracle.com/topics.html?topicId=2
Questions with answers by Steve Adams, expert on Oracle internals
site exerpt
Ixora Q A PL/SQL Space freed by recursive transactions 13 April 1999 When I rebuild a set of indexes using ALTER INDEX REBUILD from within a PL/SQL block using DBMS_SQL, the space required to perform the rebuilds is not released until all the indexes...Scripts and solutions from Oracle maven Thomas Kyte, including a PL/SQL generator to address the "update cascade" problem.
site exerpt
Oracle magazine and follow the Ask Tom link to see questions and answers or submit a question yourself. Also, here is a link: to all of the print articles that have been published in Oracle Magazine to date IDeveloper Articles...Backus-Naur Notation for PL/SQL 2.1 for Oracle 7. Old version, but still interesting.
site exerpt
BNF Index BNF Index BNF Index of PL SQL version 2.1 for Oracle 7 index on key words index on special characters plsql_block nice to start plsql_store_in_db to handle objects in database [other languages BNF] index of rules alias alter_function alter_package alter_procedure...Oracle SQL and PL/SQL tutorials from the UC Davis Database and Information Systems Group (DBIS)
site exerpt
Oracle/SQL Tutorial L tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found under www.db.cs.ucdavis.edu/dbs. References to other SQL Tutorials and Oracle related material can be...A Apache module. It aims to provide Oracle Web Application Server 3.0 API compatible interface to Oracle RDBMS. Tested with Oracle8/8i.
site exerpt
Total Knowledge: MOD_PLSQL Connect Oracle and WWW through Apache Web Server Apache module that allows you to create Web Applications using Oracle stored procedures. It works similarly to Oracle Web Application Server PL/SQL cartridge. Some features, not normally found in other similar modules are: Database connection caching. Integration with SSI Doesn't...Short tips and code fragments written (or collected) by Connor McDonald. Includes bit operations, undocumented features, and 8.1.7.
site exerpt
www.oracledba.co.uk Surely the worst piece of PL/SQL code ever 01/01/2003 Fast SYSDATE (Updated) A faster SYSDATE then SYSDATE 21/06/2002 Speed increase A simple mechanism for increasing the speed SQL within PL/SQL 24/04/2002 Array fetch (Updated)Fetching into a PL/SQL table in a...Free, reusable PL/SQL scripts; page is part of larger collection of Oracle tricks.
site exerpt
Oracle PLSQL Tips, Tricks and Utilities Function to remove symbols from a string 2. Function to validate a date 3. Function to validate a number 4. Credit card validation based on LUHN algorithm 5. U.S. Bank ABA number validation 6. Format a Social Security Number 7....Unmoderated questions and answers.
http://www.orafaq.net/msgboard/plsql/index1.htm
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
NOUG presentation on High Speed PLSQL Tuning by Rodger Lepinsky.
site exerpt
Rodger Lepinsky High Speed PLSQL Thanks to everyone who came out to see me at the NorthEast Oracle User's Group Spring training day March 17, 2004) I was worried that I would not have a very big audience, but it turned out well. As promised,...PL/SQL Tip of the Month and archives.
site exerpt
Oracle PL/SQL Pipeline Quest Software's Information Portal for Oracle PL/SQL Developers The procedure below converts a value between 1 and a (Zillion -1) to its text equivalent. CREATE OR REPLACE PROCEDURE Num2Txt(p_num IN number, p_txt OUT varchar2) IS Procedure to convert a value between 1 and a (Zillion -1) to its...An artifical intelligent agent who can be queried for Oracle Error Messages. He is currently accessible via AOL IM.
site exerpt
Consulting billboard.net Oracle Larry Bot Bot is an artifical intelligent agent who can be queried for Oracle Error Messages. He is currently accessible via AOL IM under the username oraclelarrybot Alertbox Current Alertbox: Oracle Larry Bot updated (July 25) We updated Oracle Larry Bot with...