Learn Oracle

  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 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...