AI-Assisted

Store user names and passwords in the database under a name, so PL/SQL code and jobs never contain the password itself.

Install UTL_MAIL and send e-mail from PL/SQL in one call, with copies, a MIME type, and a text or binary attachment.

Connect to any host and port from PL/SQL, write and read text lines, and speak simple protocols such as HTTP by hand.

Trust HTTPS servers from PL/SQL with the operating system's certificate store or an Oracle wallet, set with SET_WALLET.

Send JSON to a REST API with a POST request from PL/SQL, read the result, and handle requests the server rejects.

Call web services with full control: request headers, status codes, response headers, bodies, authentication, and redirects.

Send a GET request and get the response body in one call, from SQL or PL/SQL, and read JSON results in the same query.

Find the IP address of a host name, or the name of an address, as the database server resolves them.

Allow a database user to reach specific hosts and ports for HTTP, connections, or name lookups, and fix ORA-24247.

Read a text file on the database server one line at a time, detect the end of the file, and split CSV lines into fields.

Turn spaces, accented letters, and reserved characters into % codes for URLs and query values, and decode them again.

Build a compressed BLOB row by row as data is read, without holding all of it uncompressed in one variable first.

Shrink text-like BLOB and RAW data to a fraction of its size in gzip format, and see what is not worth compressing.

Read Oracle error messages in other languages and build your own messages from templates with %s and %d placeholders.

Find close matches for misspelled names and places with edit distance and Jaro-Winkler similarity scores.

Make text safe for HTML and XML, turn references back into characters, validate encodings, and look up locale data.

Turn text and binary data into Base64 for JSON, XML, and e-mail, including a BLOB encoded in pieces as a data URI.

Turn text bytes from one character set into another, such as UTF-8 into Latin-1, and see what happens to characters that do not fit.