oos-utils
oos-utils copied to clipboard
Common PL/SQL utility scripts
Link not working https://observant-message.glitch.me/oos-utils/latest/oos-utils-latest.zip used in assembly: https://github.com/Dani3lSun/docker-db-apex-dev/blob/master/files/download_urls.txt
See latest package from @antonscheffer https://github.com/antonscheffer/as_crypto
There may be issues with `oos_util_apex.is_developer_yn` in APEX 20.1
http://symbolcodes.tlt.psu.edu/bylanguage/french.html#htmlcodes
APEX items are all in string format. Dates are stored as strings so referencing `:p1_my_date` is actually a string. That string is based on either the NLS date settings OR...
Reverse engineering an APEX URL. See apex_page.get_url for the parameters that this should return. Update: - Should parse all "normal" URLs and parse into logical structures - Need to support...
When storing files in a `document` type table would be good to have a MD5 of the file so we can find duplicates etc. This can currently be done with...
A lot of applications need to store documents somewhere. They all contain the same fields that become redundant to create/manage etc. Create a generic table where applications can use as...
Sometimes we need to increase a sequence number. Options include: - dropping and recreating sequence with new `start with` value - looping over sequence until hit desired number - altering...
@antonscheffer has created `as_ftp`. If we get [permission](https://github.com/antonscheffer/as_sftp/issues/1) then we can add it as part of the library.