mortenbra/alexandria-plsql-utils — reverse-engineered prompt
Reverse engineered prompt
Build me a reusable Oracle PL/SQL utility library for database developers who need common everyday helpers without starting from scratch each time.
I want it to include packages and examples for creating and reading common file formats like PDF, Excel, CSV, RTF, XML, JSON, Office files, and zip files. It should also cover practical integrations like HTTP calls, FTP file transfer, sending and receiving email, SOAP and REST services, Amazon S3, PayPal, Google Maps, Calendar, and Translate where reasonable.
Please also include smaller helper utilities for strings, dates, math, SQL building, encoding, raw data, files, regular expressions, security, encryption, logging, debugging, random test data, and Oracle web toolkit use.
Make it easy to install into an Oracle schema, with setup scripts, organized source files, demos, and simple documentation that shows what each utility does and how to call it. Look up current Oracle PL/SQL docs online if you need to.
Want more depth? Deep Reverse