APEX: Reset default workspace password
Here is how to reset default workspace (INTERNAL) password:Run sqlplus, but from the directory, in which you have the apex sql scripts and execute the following:conn / as sysdba@apxchpwdSet the…
Weblogic Server 12c: Recover DEV_OPSS user from backup
I cannot understand the idea of critical database user like DEV_OPSS, on which weblogic server is based on, to be setup by default to expire.This is how one day I…
Oracle DB: Row_Number() function for order number
Here is an SQL, which demonstrates the use of Row_Number() function:with places_table as (select 'Africa' continent, 'Nigeria' country, 'Lagos' city from dualunionselect 'Africa' continent, 'Nigeria' country, 'Abuja' city from dualunionselect…
Oracle DB: Delete or Replace XML
Here are 2 examples of how to delete or replace xml part: Supposing that we have a variable l_xmltype of type XMLTYPE containing an XML: --delete XML;select xmltype(deletexml(xmltype('<s:a xmlns:s="qw"><s:b><return></return></s:b></s:a>'),…
Oracle OAF: Deployment
Here are the parts of deployment in OAF:a. Deploy Customizations (supposing that we have created a folder /oaf/custdocs in the source system and /oaf/custdocs_STG in the target system):1. Source System:…
Oracle OAF: Copy files to application server
Here is how different files are copied to the application server:- Controller files (CO.class): go from /myclasses/.../webui to $JAVA_TOP/.../webui- View Object files (VO.xml, VOImpl.class, VORowImpl.class): go from /myclasses/.../server to $JAVA_TOP/.../server-…
Oracle OAF: Display messages
Here are some examples from OAF types of messages:Debug Message:pageContext.writeDiagnostics(this, "CustomDebug message: milestone 01", OAFwkConstants.PROCEDURE);(Can be viewed with Diagnostics enabled on PROCEDURE level)Error Message:throw new OAException("XXX", "XXX_MY_CUSTOM_MSG", null, OAException.ERROR, null);Confirmation…
Oracle OAF: Loop through a VO
The following piece of code is an example of how we can loop a View Object (VO) and do something: public void processFormRequest(OAPageContext pageContext, OAWebBean oawebbean) { super.processFormRequest(pageContext, oawebbean); …
Oracle OAF: Forward to a new page
This code requires you to setup a new function with name XXX_CUSTOM_PAGE, specify the complete path and assign this function to your responsibility.String AuctionHeaderId = ReqRow.getAttribute("AuctionHeaderId").toString();String BidNumber = ReqRow.getAttribute("BidNumber").toString();HashMap hm…
Apache: Disable view of directory contents
In configuration file httpd.conf, replace the "Indexes" keyword with "-Indexes".The access to the specific directories that you change it, will be forbidden.For example:<Directory "${path}/www"> # # Possible values for the…