Oracle PL/SQL常用47个工具包

Oracle PL/SQL Utility Library

PL/SQL 各种常用工具包代码,包含：

PDF文件生成工具包
Excel文件生成、
RTF文件生成、
Zip文件压缩与解压、
JSON格式文件生成与解析、
通过PLSQL调用FTP、
电子邮寄SMTP、POP工具包、
SOAP and REST web services工具包、
XML、HTTP工具包等

工具包文件下载地址：

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

• PDF_BUILDER_PKG
• PDFGEN_PKG

Generate Excel files using PL/SQL

• XLSX_BUILDER_PKG
• SYLK_UTIL_PKG

Generate RTF files using PL/SQL

Working with Office 2007 (OOXML) files using PL/SQL

• OOXML_UTIL_PKG

Zip and unzip files using PL/SQL

• ZIP_UTIL_PKG

Generate and parse CSV files using PL/SQL

• CSV_UTIL_PKG

Generate and parse RSS feeds using PL/SQL

• RSS_UTIL_PKG

Generate JSON using PL/SQL

• JSON_UTIL_PKG

Parse JSON using PL/SQL

Transfer files (FTP) using PL/SQL

• FTP_UTIL_PKG

Send email (SMTP) using PL/SQL

• MAIL_UTIL_PKG

Receive email (POP3) using PL/SQL

• POP3_UTIL_PKG

Receive email (POP3 and IMAP) using PL/SQL (and Java)

Work with MS Exchange using PL/SQL

• MS_EWS_UTIL_PKG

Integrate with Google services (Google Maps, Google Calendar, Google Translate) using PL/SQL

• GOOGLE_AUTH_PKG
• GOOGLE_CALENDAR_PKG
• GOOGLE_MAPS_PKG
• GOOGLE_TRANSLATE_PKG

Integrate with Amazon web services (Simple Storage Service S3) using PL/SQL

• AMAZON_AWS_AUTH_PKG
• AMAZON_AWS_S3_PKG

Integrate with PayPal web services

• PAYPAL_UTIL_PKG

Integrate with Twitter using PL/SQL

Call SOAP and REST web services using PL/SQL

• FLEX_WS_API
• SOAP_CLIENT_UTIL_PKG
• T_SOAP_ENVELOPE

Publish SOAP web service using PL/SQL

• SOAP_SERVER_PKG

Publish REST web services using PL/SQL

Regular expressions using PL/SQL

• 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

• SQL_BUILDER_PKG
• SQL_UTIL_PKG

XML utilities

• 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

• CRYPTO_UTIL_PKG
• NTLM_UTIL_PKG
• NTLM_HTTP_PKG

Logging and debugging utilities

• DEBUG_PKG

Generating test data and random bits using PL/SQL

• RANDOM_UTIL_PKG

PL/SQL Web Toolkit (OWA) utilities

• OWA_UTIL_PKG

Web Gateways for PL/SQL

jQGrid Integration Kit for PL/SQL and Apex

Application Express APIs

• APEX_UTIL_PKG

Miscellaneous utilities and demos

PL/SQL Frameworks

PL/SQL Wrappers for Java

Unit Testing Frameworks for PL/SQL

Documentation Generators (JavaDoc-style)

Scripting, deployment and installation utilities