Requirement: In this post I will show you how we can Install Oracle WebLogic Server 12c (fmw_12.2.1.4.0_wls_lite_Disk1_1of1) in Windows Operating System (Windows 10 OS) Software Required: Below are the required Software: JDK 1.8 or higher version Oracle WebLogic Server 12c (fmw_12.2.1.4.0_wls_lite_Disk1_1of1). This software can be downloaded by clicking on https://www.oracle.com/middleware/technologies/weblogic-server-installers-downloads.html Installation Steps: To install the Oracle WebLogic Server follow the below steps: Step 1: I am assuming that the software is already downloaded. I hav ..read more

Requirement: I have an af:inputFile component for which I want to change the default style and for this I will be using be Skinning feature of Oracle ADF. Solution: For the solution of the above requirement follow the steps as shown below: Step 1: Create an ADF Fusion Web Application. Step 2: Create a demo.jspx page. Drag and drop af:inputFile and set label=”Browse and Select” Thus, the complete code for the demo.jspx page is shown below. <?xml version='1.0' encoding='UTF-8'?> <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1" xmlns:f="http://java.sun.com/jsf/core ..read more

Requirement: I have an af:inputDate component. Also, I have a list of holidays defined in a Managed Bean. Now I want to disable and highlight all the holidays in Red Color. Solution: For the solution of the above requirement follow the steps as shown below: Step 1: Create an ADF Fusion Web Application. Step 2: Create a demo.jspx page. Drag and drop af:panelBox inside the demo.jspx page and set text=”Show Holidays as Disabled and Highlighted” and showDisclosure=”false” Drag and drop af:inputDate inside the af:panelBox and set label=”Select Date” and disabledDays=”#{pageFlowScope.MyBean}” Thus ..read more

Requirement: I have an af:inputText field where I can enter the Salary. We also have three buttons with the text as English, French, and German. Now, when the user clicks on any of these buttons it should change the Locale accordingly. For example, if the user clicks on the French button it should display the Salary value in French Locale. Solution: For the solution of the above requirement follow the steps as shown below: Step 1: Create an ADF Fusion Web Application. Step 2: Create a demo.jspx page. Drag and drop af:panelBox inside the demo.jspx page and set text=”Number Format according to L ..read more

Requirement: I want to execute the PL/SQL Procedure with IN and OUT Parameters in Oracle. Solution: For the solution of the above requirement, let us first create the PL/SQL procedure having both the IN and OUT parameters. Thus, the complete code for the PL/SQL procedure is shown below: CREATE OR REPLACE PROCEDURE proc_getempdetails ( ip_emp_no IN NUMBER, op_f_name OUT VARCHAR2, op_l_name OUT VARCHAR2 ) IS BEGIN SELECT first_name, last_name INTO op_f_name, op_l_name FROM employees WHERE employee_id = ip_emp_no ..read more

Requirement: I have a PL/SQL Procedure with the name proc_getempdetails having an input parameter ip_emp_no and two output parameters op_f_name and op_l_name When the user provides the valid ip_emp_no and invokes the proc_getempdetails procedure it should return the corresponding First Name and Last Name for that Employee. Solution: For the solution of the above requirement follow the steps as shown below: Step 1: Create an Oracle PL/SQL Procedure with the name as proc_getempdetails hhaving an input parameter ip_emp_no and two output parameters op_f_name and op_l_name. Thus, the complete code ..read more

Requirement: In this post I will show you how we can programmatically Define, Set, Get and Remove Named Bind Variable from a ViewObject in Oracle ADF We can define the WHERE Clause, Bind Variable Name and the Default Value by using the below code. // Get the ViewObject ViewObject vo = iter.getDepartments(); // Apply desired WHERE Clause and declare the bind variable name vo.setWhereClause("DEPARTMENT_NAME=:bindDeptName"); // Define this variable as ViewObject Bind Variable. We can also set default value for this vo.defineNamedWhereClauseParam("bindDeptName", "Marketing", null); // Execute th ..read more

Requirement: I have a PL/SQL Stored Function with the name as fn_getDepartmentName having an input parameter i_dept_id When the user provides the valid i_dept_id and invokes the fn_getDepartmentName function it should return the corresponding Department Name. Solution: For the solution of the above requirement follow the steps as shown below: Step 1: Create an Oracle PL/SQL Stored Function with the name as fn_getDepartmentName having an input parameter i_dept_id. Thus, the complete code for the fn_getDepartmentName function is shown below: CREATE OR REPLACE FUNCTION fn_getDepartmentName ..read more

Requirement: I have a demo.jspx to Upload and Display the image file from the Absolute Server Path. In case we load the demo.jspx for the first time it will display the screen as shown below: The Absolute Server Path, in this case, is C:\Users\Susanto\Desktop\MyFolder Now, when the user uploads the image it should display that uploaded image in the demo.jspx. The image file name will be generated based on some timestamp logic. The file will also be stored in the absolute server path. Next time when the user uploads the new image it should display that newly uploaded image in the demo.jspx ..read more

Requirement: I want to Upload a File in the Absolute Server Path, and the details about the uploaded files will be stored in the Oracle Database Table. Then in the user interface, we will be having the table displaying the file details and one of the columns in this table is the Download hyperlink on click of which it will download the corresponding file. Solution: For the solution of the above requirement follow the steps as shown below. Step 1: Create a file_upload_download table in the Oracle Database. The table creation script is as below: CREATE TABLE file_upload_download ( file_na ..read more