3shTech

   UPLOAD BUTTON (logic below): Excel sheet column structure: Table Structure: Code inside Controller: public void processFormRequest(OAPageContext  pageContext,  OAWebBean    webBean) {      super.processFormRequest(pageContext, webBean);      OAApplicationModule  am = (OAApplicationModule)pageContext.getApplicationModule(webBean);      String   filename   = null;      String   fname       = null;      String   ext            = null;     pageContext.writeDiagnostics(this,"Inside PFR..",1);      if(pageContext.getParameter("UploadBtn") != null)   //ID of the Upload button       {                DataObject   upload  =  pageContext.getNamedDataObject("FileUpload");  //import orac...

    3shTech (trainings@trishtechnology.com) String Functions Numeric Functions Group Functions Date Functions Conversion Functions Analytical Functions RANK , DENSE_RANK   SELECT employee_id,first_name,salary ,department_id       ,RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) "Rank_emp"       ,DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) "Dense_Rank_emp"   FROM hr.employees   ORDER BY department_id;         LEAD , LAG   SELECT employee_id,first_name,salary ,department_id       ,LAG(salary) OVER (ORDER BY salary DESC) "Previous"       ,LEAD(salary) OVER (ORDER BY salary DESC ) "Next"   FROM hr.employees;         REGEXPR_SUBSTR   The regular expression matching information. It can be a combination of the following: ...