Posts

 Create Online Resume using HTML Step-1 Create a page called Online Resume Step-2 Create a static Region called Online Resume in source HTML Code write the following code: <div class="container-fluid cv-page">   <div class="row">     <div class="col-4">       <section class="section__left">         <article class="avatar">           <div class="frame"></div>           <div class="image">             <img src="#APP_FILES#Nasim Vai.jpg">           </div>         </article>         <article class="info">           <p class="name">Nur Nabi Nasim Ahmed</p>           <p class="role">Full Stack Developer (Oracle)</p>         </arti...

Manual Scrollable Master Detail Page in oracle apex part-2

 ** Please find the previous part-1 text instruction in : https://learnoracle21.blogspot.com/2024/01/manual-scrollable-master-detail-page-in.html Manual Scrollable Master Detail Page in oracle apex part-2 Add a plugins named Select2 in shared component for item visualization. Download plugins using url: http://apex.oracle.com/pls/apex/f?p=64237:20 Step-1 Create a static region names Employee Detail Info and add a server side condition =ITEM IS NOT NUll item = P16_ID (To display the region))  add the following item in employee_Detail_info region: P16_TEMP_ID  type=hidden value protected= no add a dynamic action called store_temp_id: action= execute server side code: begin for i in (SELECT  ID,EMPLOYEE_ID,EMPLOYEE_BASIC_ID,DEPT_ID,SAL_GRA_BAS_ID,SBU_ID,UNIT_ID,DIVISSION_ID,DISTRICT_ID,THANA_ID,           DESIGNATION_ID,GRADE_ID,EMPLOYEE_TYPE_ID,SHIFT_ID,ZONE_ID,BRANCH_ID ,IS_ACTIVE,SYSTEM_DATE,service_type ,service_catagory,emp_cat,EMP_DUTY_TYP...
  Manual Scrollable Master Detail Page in Oracle Apex part-1 Step -1 create a page classic Report Page (All Employees) using this sql query : select aa.ID, aa.FAST_NAME||' '||aa.MNAME||' '||aa.LNAME "Full Name", aa.FATHER_NAME, aa.MOTHER_NAME, aa.JOINING_DATE, aa.NID, AA.TIN, aa.EMAIL, aa.PASSPORT, aa.MOBILE, (SELECT CASE WHEN NVL (DBMS_LOB.getlength (EMPLOYEE_IMAGE), 0) = 0 THEN NULL ELSE '<img width="80px" src="' || APEX_UTIL. get_blob_file_src ('P16_EMPLOYEE_IMAGE', ID) || '" />' END FROM EMPLOYEE_BASIC where id=aa.id) AS PICTURE from EMPLOYEE_BASIC aa Step-3 add a button called CREATE as level (New Employee) In Button Behaviour property redirect this page to form page (Page 23). Step-4 In form Page: *in ...

Oracle apex login page beautification Tutorial

Image
  Oracle apex login page beautification Tutorial Script: 1. First create or modify your login page 2. Change login page template as go to page level property -> Appearance -> Template Options -> set template page layout as split 3. Download a background image from freepik.com 4. upload this background image in your apex application shared folder: 4. Add the below javascript code to your login page -> page level -> inline -> paste the code Javascript code: .t-PageBody--login form#wwvFlowForm{ background:url( #WORKSPACE_FILES #Capture.jpg); background-repeat:no-repeat; background-Size:cover; } Span.t-Login-logo{ background-image : url( #WORKSPACE_FILES #logo_learn_oracle.png); background-Size :cover; width :75px; height :75px; } .t-Login-region{ position:relative; width:400px; --height:300px; margin:0Auto; background:rgba(165, 145, 145, 0.3); padding:20px 22px; border:1px solid; border-top-color: #fbce4a ; border-l...
Image
  Jasper Server and studio complete installation step by step   Step -1   Download 1. jaspersoft studio 2. jasperserver from official TIBCO website   Step-2   Install jaspersoft studio Install jasperserver   Step 3   Jasper Report Integration   First Check your System Environment Variable (For Windows same as linux)   Right clock on: This PC/My Computer icon ->Properties ->Advance System ->Advance ->Environment Variable ->System Variable ->select Path ->edit ->new ->C:\Windows\SysWOW64 ->move up under C:\Windows\System32 position ->apply ok ->ok   Install JDK latest version (if not installed)   again add jre path to environment variable   Right clock on: This PC/My Computer icon ->Properties ->Advance System ->Advance ->Environment Variable ->System Variable ->select Path ->edit -...