2014 – SWKB.NET

Weblogic Server 12c: Recover DEV_OPSS user from backup

Post author:admin
Post published:November 20, 2014
Post category:WebLogic
Post comments:0 Comments

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

Post author:admin
Post published:November 11, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:September 13, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Oracle OAF: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Oracle OAF: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Oracle OAF: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Oracle OAF: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Oracle OAF: How To Examples
Post comments:0 Comments

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

Post author:admin
Post published:August 30, 2014
Post category:Apache
Post comments:0 Comments

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…

Oracle DB: Scheduled Jobs

Post author:admin
Post published:August 14, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

Here is how to program a scheduled job in Oracle DB to run at specific date and time:The following job will run at 17:00 every day:SET DEFINE OFF;DECLARE X NUMBER;BEGIN …