Trent's Tech Tips

I posted the other day about getting going with Golang[ 1 ], and as mentioned am planning to do a series of posts on various aspects of the language - as a means to help with the learning process. Being an Oracle developer, it seemed logical I would want to be able to make connections to the Oracle database. Built into the language core is an SQL interface (for issuing queries and statements) which is through the module "database/sql". The other side of it is that you need a valid driver. A list of available drivers is on the go wiki[ 2 ]. You will see that there are 2 listed for Oracle. How do I judge which project to use? First I see that one has considerably more stars and for another, the online commentary I see also seems to suggest that same package. And that is  https://github.com/mattn/go-oci8 . Driver setup Before we get to the driver, you need to make sure you have an Oracle client and the SDK installed on your system. For, this I followed the steps as per the...

Say for example you have a generic build status of 'Exclude' - so you can temporarily disable components without touching the conditions (it doesn't really seem in the nature of build options, but still can be done). There will undoubtedly come a time where you need to locate all said components to either remove them from the application, or remove the build option so they are re-included. First we can query the apex_dictionary view to find any views that contain the build option column: select * from apex_dictionary where column_name = 'BUILD_OPTION' As at ApEx 4.2, this gives us the following list: APEX_APPL_USER_INTERFACES APEX_APPLICATION_BC_ENTRIES APEX_APPLICATION_COMPUTATIONS APEX_APPLICATION_ITEMS APEX_APPLICATION_LISTS APEX_APPLICATION_LIST_ENTRIES APEX_APPLICATION_LOV_ENTRIES APEX_APPLICATION_NAV_BAR APEX_APPLICATION_PAGES APEX_APPLICATION_PAGE_BRANCHES APEX_APPLICATION_PAGE_COMP APEX_APPLICATION_PAGE_DA APEX_APPLICATION_PAGE_PROC A...