Modify CSS for Single Item in Form

 #P9_SPEED_COUNTER{

padding-top: .1rem;

}

#P9_SPEED_LABEL{

font-size: 2.5rem;

}

#P9_SPEED{

font-size: 5rem;

min-height:13rem;

}

Show profile picture in top right corner on menu bar in oracle apex

1.  Create a table with blob cloumn 

create table user_info 

(

 user_id varchar2(50),

 user_name varchar2(200),

 user_photo    blob,

 filename    varchar2(3000),

 mimetype    varchar2(3000),

 last_update    date ,

 wk_date    date  default  to_date(sysdate,'DD-MON-RR'),

 wk_time    varchar2(50)  default  to_char (sysdate,'HH24:MI:SS')

)

/

1.Create application item name > 'USER_ID',> Session State Protection > Unrestricted.
2.Create Application Processes > 'GETIMAGEFILE',> Process Point > Ajax Callback, > PL/SQL Code >
begin
for c1 in (select * from employee_information
                where USER_ID= :USER_ID) loop
        sys.htp.init;
      sys.owa_util.mime_header( c1.MIME_TYPE, FALSE );
      sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.PICTURE));
     sys.htp.p('Content-Disposition: attachment; filename="' || c1.FILENAME || '"' );
       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.PICTURE);
     apex_application.stop_apex_engine;
         end loop;
         end;
3.Create/Select navigation bar where you want to show image > User Defined Attributes 1.
<img style="width:25px;height:25px;border-radius:50%;cornflowerblue" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGEFILE:::USER_ID:&APP_USER." alt=" ">

Combination of some fields in a formula where some fields are null

 If IsNull({X_MONEY_RECEIPTS_REP.ORDER_CODE}) Then

    {X_MONEY_RECEIPTS_REP.IDENTITY}

Else

    {X_MONEY_RECEIPTS_REP.IDENTITY}+" / "+{X_MONEY_RECEIPTS_REP.ORDER_CODE}

remove ORA Code from process execution in Oracle APEX

Error

Error Message

 <h7 style="color: #d00;">#SQLERRM_TEXT# </h7>

SEND MAIL form Gmail to Gmail using oracle apex

If u use gmail as mail server, then configuration like
SMTP server: smtp.gmail.com
SMTP username: Your full gmail address (e.g. example@gmail.com)
SMTP password: Your Gmail password
SMTP port: 465

Or if own mail server, then configure like
SMTP server: mail.yourdomain.com or smtp.yourdomain.com
SMTP username: Your full email address (e.g. example@yourdomain.com)
SMTP password: Your email password
SMTP port: 25/26

DECLARE

  l_acl_name         VARCHAR2(30) := 'utl_tcp.xml';

  l_ftp_server_ip    VARCHAR2(20) := 'smtp.gmail.com';

  l_ftp_server_name  VARCHAR2(20) := 'smtp.gmail.com';

  l_username         VARCHAR2(30) := 'TEST';

BEGIN

  DBMS_NETWORK_ACL_ADMIN.create_acl (

    acl          => l_acl_name, 

    description  => 'Allow connections using UTL_TCP',

    principal    => l_username,

    is_grant     => TRUE, 

    privilege    => 'connect',

    start_date   => SYSTIMESTAMP,

    end_date     => NULL);

  COMMIT;

  DBMS_NETWORK_ACL_ADMIN.add_privilege ( 

    acl         => l_acl_name, 

    principal   => l_username,

    is_grant    => FALSE, 

    privilege   => 'connect', 

    position    => NULL, 

    start_date  => NULL,

    end_date    => NULL);

  COMMIT;

  DBMS_NETWORK_ACL_ADMIN.assign_acl (

    acl         => l_acl_name,

    host        => l_ftp_server_ip, 

    lower_port  => NULL,

    upper_port  => NULL);

  DBMS_NETWORK_ACL_ADMIN.assign_acl (

    acl         => l_acl_name,

    host        => l_ftp_server_name, 

    lower_port  => NULL,

    upper_port  => NULL);

  COMMIT;

END;

Oracle Apex Cloud Messenger

create table cloud_userinformation_tab

(

    id    number,

username  varchar2(80),

oldusername   varchar2(80),

nickname     varchar2(50),

gender    varchar2(50),

country   varchar2(80),

profilpic   blob,

MimeType  varchar2(2000),

FileName  varchar2(2000),

CharacterSet varchar2(2000),

BLOBLastUpdated date,

entrydate date,

updatedate date

)

 create table cloud_Messenger

(id  number,

text  varchar2(4000),

blobfile  blob,

MimeType  varchar2(2000),

FileName  varchar2(2000),

CharacterSet varchar2(2000),

BLOBLastUpdated date,

username varchar2(80),

entrydatetime  varchar2(80) , 

updatedatetime varchar2(80)

)