Oracle PL/SQL 工具包收集

# alexandria-plsql-utils Oracle PL/SQL Utility Library <img src="http://plsql-utils.googlecode.com/files/alexandria-logo.jpg"> This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere. ##Generate PDF files using PL/SQL * http://technology.amis.nl/2012/04/11/generating-a-pdf-document-with-some-plsql-as_pdf_mini-as_pdf3/ * http://technology.amis.nl/blog/8650/as_pdf-generating-a-pdf-document-with-some-plsql * http://www.erasme.org/PL-FPDF,1337?lang=en * http://ora-00001.blogspot.com/2009/10/free-pdf-package-for-plsql.html * http://sourceforge.net/projects/pljrxml2pdf/ * http://www.plpdf.com/ * PDF_BUILDER_PKG * PDFGEN_PKG ##Generate Excel files using PL/SQL * http://technology.amis.nl/blog/10995/create-an-excel-file-with-plsql * http://www.jasonsdevelopercorner.com/?page_id=8 * https://xml-spreadsheet.samplecode.oracle.com/ * http://sanjeev-oracle-world.blogspot.com/2007/06/create-excel-workbook-by-plsql-code.html * http://matzberger.de/oracle/spreadsheet-en.html * http://www.protalk.in/oracle/plsql-tips-package-for-exporting-data-to-excel/ * XLSX_BUILDER_PKG * SYLK_UTIL_PKG ##Generate RTF files using PL/SQL * http://monkeyonoracle.blogspot.com/2009/07/dynamic-rtf-documents-revisited.html ##Working with Office 2007 (OOXML) files using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/1/1b/X-office-document.svg/48px-X-office-document.svg.png" align="right" /><img src="http://upload.wikimedia.org/wikipedia/commons/thumb/0/07/X-office-presentation.svg/48px-X-office-presentation.svg.png" align="right" /><img src="http://upload.wikimedia.org/wikipedia/commons/thumb/f/f8/X-office-spreadsheet.svg/48px-X-office-spreadsheet.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2011/02/working-with-office-2007-ooxml-files.html * http://technology.amis.nl/blog/8090/parsing-a-microsoft-word-docx-and-unzip-zipfiles-with-plsql * http://www.docufy.be/ * OOXML_UTIL_PKG ##Zip and unzip files using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/9/9c/The_Unarchiver_zip.png/64px-The_Unarchiver_zip.png" align="right" /><br> * http://technology.amis.nl/blog/7626/utl_compress-gzip-and-zlib * ZIP_UTIL_PKG ##Generate and parse CSV files using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/3/38/CsvDelimited001.svg/113px-CsvDelimited001.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2010/04/select-from-spreadsheet-or-how-to-parse.html * CSV_UTIL_PKG ##Generate and parse RSS feeds using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/4/43/Feed-icon.svg/75px-Feed-icon.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-one.html * http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-two.html * RSS_UTIL_PKG ##Generate JSON using PL/SQL * http://ora-00001.blogspot.com/2010/02/ref-cursor-to-json.html * JSON_UTIL_PKG ##Parse JSON using PL/SQL * http://sourceforge.net/projects/pljson/ * http://reseau.erasme.org/pl-sql-library-for-JSON?lang=en ##Transfer files (FTP) using PL/SQL * http://www.oracle-base.com/articles/misc/FTPFromPLSQL.php * FTP_UTIL_PKG ##Send email (SMTP) using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/b/b1/Arobaze.svg/75px-Arobaze.svg.png" align="right" /><br> * http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html * http://download.oracle.com/docs/cd/E10513_01/doc/apirefs.310/e12855/apex_mail.htm * MAIL_UTIL_PKG ##Receive email (POP3) using PL/SQL * POP3_UTIL_PKG ##Receive email (POP3 and IMAP) using PL/SQL (and Java) * http://plsqlmailclient.sourceforge.net/ ##Work with MS Exchange using PL/SQL * http://ora-00001.blogspot.com/2012/05/ms-exchange-api-for-plsql.html * MS_EWS_UTIL_PKG ##Integrate with Google services (Google Maps, Google Calendar, Google Translate) using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/3/30/Googlelogo.png/200px-Googlelogo.png" align="right" /><br> * http://ora-00001.blogspot.com/2009/12/using-google-translate-from-plsql.html * GOOGLE_AUTH_PKG * GOOGLE_CALENDAR_PKG * GOOGLE_MAPS_PKG * GOOGLE_TRANSLATE_PKG ##Integrate with Amazon web services (Simple Storage Service S3) using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/en/thumb/1/1d/AmazonWebservices_Logo.svg/250px-AmazonWebservices_Logo.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2011/03/amazon-s3-api-for-plsql.html * http://jastraub.blogspot.com/2011/01/building-amazon-s3-client-with.html * AMAZON_AWS_AUTH_PKG * AMAZON_AWS_S3_PKG ##Integrate with PayPal web services <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/3/39/PayPal_logo.svg/200px-PayPal_logo.svg.png" align="right" /><br> * PAYPAL_UTIL_PKG ##Integrate with Twitter using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/en/9/9f/Twitter_bird_logo_2012.svg" width="100" align="right" /><br> * http://oratweet.com/ ##Call SOAP and REST web services using PL/SQL * http://jastraub.blogspot.com/2008/06/flexible-web-service-api.html * https://flex-ws-api.samplecode.oracle.com/ * http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/apex_web_service.htm#BABFFDEH * http://ora-00001.blogspot.com/2009/07/calling-soap-web-service-from-plsql-by.html * FLEX_WS_API * SOAP_CLIENT_UTIL_PKG * T_SOAP_ENVELOPE ##Publish SOAP web service using PL/SQL <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/5/59/SOAP.svg/182px-SOAP.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2011/01/soap-server-in-plsql.html * SOAP_SERVER_PKG ##Publish REST web services using PL/SQL * http://ora-00001.blogspot.com/2009/07/creating-rest-web-service-with-plsql.html * http://www.oracle-base.com/articles/misc/XMLOverHTTP.php ##Regular expressions using PL/SQL <img src="http://upload.wikimedia.org/math/2/a/8/2a8ea57cab60c6ac9279fbf68e37ba0d.png" align="right" /><br> * REGEXP_UTIL_PKG ##String, date and math utilities * DATE_UTIL_PKG * MATH_UTIL_PKG * STRING_UTIL_PKG ##Encoding and data type utilities * ENCODE_UTIL_PKG * RAW_UTIL_PKG ##SQL utilities <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/a/aa/SQL_ANATOMY_wiki.svg/275px-SQL_ANATOMY_wiki.svg.png" align="right" /><br> * SQL_BUILDER_PKG * SQL_UTIL_PKG ##XML utilities <img src="http://upload.wikimedia.org/wikipedia/commons/thumb/6/68/XML.svg/125px-XML.svg.png" align="right" /><br> * http://ora-00001.blogspot.com/2011/02/display-any-xml-as-clickable-tree-using.html * XML_BUILDER_PKG * XML_DATASET_PKG * XML_STYLESHEET_PKG * XML_UTIL_PKG ##File utilities * FILE_UTIL_PKG ##HTTP utilities * HTTP_UTIL_PKG ##Encryption and security utilities and protocols * http://ora-00001.blogspot.com/2011/08/ntlm-for-plsql.html * CRYPTO_UTIL_PKG * NTLM_UTIL_PKG * NTLM_HTTP_PKG ##Logging and debugging utilities * https://github.com/tmuth/Logger---A-PL-SQL-Logging-Utility * http://sourceforge.net/projects/log4plsql/ * http://sourceforge.net/projects/ilo/ * DEBUG_PKG ##Generating test data and random bits using PL/SQL * http://ora-00001.blogspot.com/2011/02/generating-test-data-using-plsql.html * RANDOM_UTIL_PKG ##PL/SQL Web Toolkit (OWA) utilities * OWA_UTIL_PKG ##Web Gateways for PL/SQL * http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm * http://download.oracle.com/docs/cd/B14099_19/web.1012/b14010/toc.htm * http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html * http://code.google.com/p/thoth-gateway/ * http://sourceforge.net/projects/dbprism/ * http://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm ##jQGrid Integration Kit for PL/SQL and Apex * http://ora-00001.blogspot.com/201