47 common Oracle PL/SQL Toolkit, oracleplsql47
Oracle PL/SQL Utility Library
Common PL/SQL Toolkit code, including:
PDF file generation Toolkit: Excel file generation, RTF file generation, Zip file compression and decompression, JSON file generation and parsing, FTP call through PLSQL, SMTP by email, POP toolkit, SOAP and REST web services toolkit, XML, HTTP toolkit, etc.
Toolkit file:
Http://download.csdn.net/detail/sunansheng/8728337
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/
- Performance_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
- 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
- Http://technology.amis.nl/blog/7626/utl_compress-gzip-and-zlib
- ZIP_UTIL_PKG
Generate and parse CSV files using PL/SQL
- 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
- 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
- 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
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
- 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
- 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
Integrate with Twitter using PL/SQL
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
- 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
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
- SQL _BUILDER_PKG
- SQL _UTIL_PKG
XML utilities
- 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
HTTP utilities
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
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/2010/03/jqgrid-integration-kit-for-plsql-and.html
- Http://code.google.com/p/jqgrid-for-plsql/
Application Express APIs
- Http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/toc.htm
- APEX_UTIL_PKG
Miscellaneous utilities and demos
- Http://www.toadworld.com/Portals/0/stevenf/demo.zip
- Http://www.toadworld.com/ORACLE/StevenFeuersteinsPLSQLObsession/tabid/153/Default.aspx
PL/SQL Frameworks
- Http://sourceforge.net/projects/plsqlframestart/
- Http://www.toadworld.com/Freeware/PLVisionFreeware/tabid/687/Default.aspx
PL/SQL Wrappers for Java
- Http://sourceforge.net/projects/oracle-jutils/
Unit Testing Frameworks for PL/SQL
- Http://sourceforge.net/projects/utplsql/
- Http://code.google.com/p/pluto-test-framework/
Documentation Generators (JavaDoc-style)
- Http://sourceforge.net/projects/plsqlutils/
- Http://www.thatjeffsmith.com/archive/2012/03/javadoc-for-the-database-a-la-dbdoc-via-sql-developer/
Scripting, deployment and installation utilities
- Http://code.google.com/p/oracle-ddl2svn/
