How to show profile picture in top right Conner in oracle apex

1. Table Scripts
 create table emp1
 (
  EMPNO                                              NUMBER(4)
 ,ENAME                                              VARCHAR2(10)
 ,HIREDATE                                           DATE
 ,IMAGE                                              BLOB
 ,IMG_TYP                                            VARCHAR2(100)
 ,IMG_NM                                             VARCHAR2(100)
)


2. Create application item in sharecomponnent
Name          :  FILE_ID
Condition     : Unrestricted

3. Create Application Processes

Name          : GETIMAGE
Process Point : Ajax Callback: Run this application process when requested by a page process.

PL/SQL Anonymous Block Code


begin
    for c1 in (select * from emp1
                where EMPNO = :FILE_ID) loop
        --
        sys.htp.init;
        sys.owa_util.mime_header( c1.img_typ, FALSE );
        sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.IMAGE));
        sys.htp.p('Content-Disposition: attachment; filename="' || c1.img_nm || '"' );
        sys.htp.p('Cache-Control: max-age=3600');  -- tell the browser to cache for one hour, adjust as necessary
        sys.owa_util.http_header_close;
        sys.wpg_docload.download_file( c1.IMAGE );
   
        apex_application.stop_apex_engine;
    end loop;
end;

4.
Shared ComponentsList\ Details\ Create Entry
Template : Nabigation Bar
         : Check Transalator
first row paste
<img style="width:42px;height:42px;border-radius: 50px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">

Thanks

//or
<img style="width:30px;height:30px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">



Theme Roller  CSS for remove background box in oracle apex...

.t-Button--navBar .t-Button-badge { border-radius: 16px; background-color: #0076df; }

how to solved Apex Applications manu bar may not show on mobile device

You can solve this problem by doing this Dynamic Action.

1. Create a Dynamic Action in  0 page.

2.Set Event  : Page Load  Execute JavaScript Code

3. Set Action : Execute JavaScript Code Now you can try on mobile device

4. Then copy pest this JavaScript  Code :

$(".t-Header-nav").removeClass("t-Header-nav");

Now you can try on mobile device.

marquee in oracle apex using html

<marquee behavior="scroll" direction="left" scrollamount="10">Fast Scrolling</marquee>

<marquee> This is a marquee </marquee>

<marquee direction="right">Welcome to Star Ceramics Limited in Bangladesh                                                                                            </marquee>

<marquee behavior="alternate">Welcome to Star Ceramics Limited in Bangladesh  </marquee>


<marquee behavior="scroll" direction="left" scrollamount="10">Fast Scrolling</marquee>

<marquee direction="scroll">A scrolling text created with HTML Marquee element and styled with CSS properties.</marquee>

<marquee behavior="alternate">This is alternate behavior of a marquee </marquee>

<marquee scrolldelay="10">This is a marquee with scrolldelay 10</marquee>
<marquee scrolldelay="25">This is a marquee with scrolldelay  25</marquee>
<marquee scrolldelay="50">This is a marquee with scrolldelay  50</marquee>
<marquee scrolldelay="100">This is a marquee with scrolldelay  100</marquee>
<marquee scrolldelay="200">This is a marquee with scrolldelay  200</marquee>
<marquee scrolldelay="300">This is a marquee with scrolldelay  300</marquee>
<marquee scrolldelay="500">This is a marquee with scrolldelay  500</marquee>
<marquee scrolldelay="1000">This is a marquee with scrolldelay  1000</marquee>

<marquee onmouseover="stop()">This marquee will stop on mouseover.</marquee>

<marquee onmouseover="stop()" onmouseout="start()">This marquee will stop on mouseover and restart on mouseout.</marquee>

oracle apex item shape round

item  -->> advance -->> attribute

 style="border:.1em solid #309fdb;width: 50%;border-radius: 20px;"

last row in oracle table in sql

select
  EMP_ID
from
  IT_INV_ISSUE_FORM
where
  rowid =(
    select
       max(rowid)
    from
       IT_INV_ISSUE_FORM)

apex profile pic

$('html')
   .bind(
       'click',
       function(e) {
              if ($('#exitpopup_bg').dialog('isOpen') &&!$(e.target). is('.ui-dialog,a') && !$(e.target).closest('.ui-dialog').length && !$(e.)
                 
                  $('.image_icon').removeClass('et');
                  $('.image_icon').addClass('st');
                 }
            }
      }

);


var imageurl=$('#P1_IMAGE').attr('src');
$('.image_icon').css('background-image','url('+imageurl + ')');


select profile_img from user_control
where user_name='AAA';
&PROFIL.
image_icon st

&PROFIL.








////////////////////////////////

/* Close when click Outside the Dialog*/
$('html')
    .bind(
        'click',
        function(e) {
            if ($('#exitpopup_bg').dialog('isOpen') && !$(e.target).is('.ui-dialog, a') && !$(e.target).closest('.ui-dialog').length && !$(e.target).is('.image_icon')&&!$(e.target).is('.ui-dialog-titlebar-close')) {
                $('#exitpopup_bg').dialog('close');


                $('.image_icon').removeClass('et');
                $('.image_icon').addClass('st');
            }
        }
    );



var imageurl=$('#P1_IMAGE').attr('src');
$('.image_icon').css('background-image','url('+imageurl + ')');


select IMAGE from EMP1
where EMPNO=210
&PROFIL.
image_icon st

&PROFIL.

refresh using htlm in apge

page html header --


<meta http-equiv="refresh" content="10">

how to update table using cursor with number of total update rows display in sql command

set serveroutput on

DECLARE 
   total_rows number(2); 
BEGIN 
   UPDATE  STUDENT 
   SET CITY = 'Dhaka'
   where stid in ('1','2'); 
   IF sql%notfound THEN 
      dbms_output.put_line('no customers updated'); 
   ELSIF sql%found THEN 
      total_rows := sql%rowcount; 
      dbms_output.put_line( total_rows || ' customers updated '); 
   END IF; 
END; 
/