Trent's Tech Tips

APEX comes with an API - APEX_INSTANCE_ADMIN - where you can both get and set instance preferences. There is a list of available properties on the documentation, however I found that not all preferences were documented there. For example, in Feature Configuration, there are some preferences surrounding packaged applications: Looking at the documentation,  https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_instance.htm#CHDFEICJ , you may find it difficult locating these. Then, there other properties in there that I don't think are relevant any more (..but not an expert on the subject, so may be wrong). Lets take the example of  PASSWORD_HISTORY_DAYS  - this states " Defines the maximum number of days a developer or administrator account password may be used before the account expires. The default value is 45 days. ". We can locate the property it's talking about under Security - Authentication Control - Development Environment Settings. ...

Based on the current beta API docs:  https://docs.oracle.com/cd/E59726_01/doc.50/e39149/toc.htm , here is what's changed. APEX_APPLICATION_INSTALL Function GET_AUTO_INSTALL_SUP_OBJ added  Procedure SET_AUTO_INSTALL_SUP_OBJ added APEX_CUSTOM_AUTH LOGOUT procedure deprecated APEX_ESCAPE Function JSON added Function REGEXP added APEX_INSTANCE_ADMIN Procedure CREATE_SCHEMA_EXCEPTION added Procedure FREE_WORKSPACE_APP_IDS added Function GET_WORKSPACE_PARAMETER added Procedure REMOVE_SCHEMA_EXCEPTION added Procedure REMOVE_SCHEMA_EXCEPTIONS added Procedure REMOVE_WORKSPACE_EXCEPTIONS added Procedure RESERVE_WORKSPACE_APP_IDS added Procedure RESTRICT_SCHEMA added Procedure SET_WORKSPACE_PARAMETER added Procedure UNRESTRICT_SCHEMA added APEX_IR Procedure CHANGE_SUBSCRIPTION_EMAIL added Procedure CHANGE_REPORT_OWNER added APEX_LDAP Function SEARCH added APEX_PLUGIN_UTIL Function GET_ATTRIBUTE_AS_NUMBER added APEX_UTIL Procedure CLOSE_O...

Overview I happened to be watching some Google I/O videos from 2013 last week and was watching some on apps-script, which I had never really used up until now. They mentioned about having JDBC connector so that you could connect to external data sources (Oracle, MySQL, SQL Server, etc). It's worth noting, there are 2 types scripts that can be container bound to a spreadsheet: 1. Add ons 2. Script gallery Script gallery is not supported in the new version of sheets, in favour of add-ons. There is a market place where you can search for and install add-ons, and if your organisation is using google apps, you can even restrict your add-on to your organisation. Unlike the script gallery where you could view the source, that is not the case for Add-ons (the code is not visible to end users). Excluding if you share the document with the development version of the code attached to the document. Add-ons are currently in developer preview, so whilst you can develop add-ons, only...