mortenbra/alexandria-plsql-utils

This is stars and forks stats for /mortenbra/alexandria-plsql-utils repository. As of 26 Apr, 2024 this repository has 738 stars and 311 forks.

alexandria-plsql-utils Oracle PL/SQL Utility Library 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 https://technology.amis.nl/2012/04/11/generating-a-pdf-document-with-some-plsql-as_pdf_mini-as_pdf3/ https://technology.amis.nl/2010/10/20/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 https://technology.amis.nl/2011/02/19/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 https://technology.amis.nl/2010/06/09/parsing-a-microsoft-word-docx-and-unzip-zipfiles-with-plsql/ http://www.docufy.be/ OOXML_UTIL_PKG Zip and unzip files using PL/SQL https://technology.amis.nl/2010/03/13/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 https://github.com/pljson/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 https://oracle-base.com/articles/misc/email-from-oracle-plsql https://docs.oracle.com/en/database/oracle/application-express/19.1/aeapi/APEX_MAIL.html 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 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 PAYPAL_UTIL_PKG Integrate with Twitter using PL/SQL 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 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 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 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/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.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip http://www.toadworld.com/platforms/oracle/w/wiki/8243.plsql-obsession 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 https://utplsql.github.io/ 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/