Overlap Region And Chat box Button

Overlap Region

1. Create a region and then region properties>> Appearance>> CSS Class>>  a-DevToolbar a-DevToolbar a-DevToolbar--right

Chat Box Button
1. Create a button and fixed a ID in static ID Then Copy pest the below CSS into Style

<style>
#id{
  z-index:100;
  position:fixed;
  width:60px;
  height:60px;
  bottom:40px;
  right:40px;
  background-color: rgba(55, 76, 139, 0.81);
  color:#FFF;
  border-radius:50px;
  text-align:center;
  box-shadow: 2px 2px 3px #999;
}
.my-id{
  margin-top:22px;
}
</style>

Footer Fixed On Bottom Of The Screen CSS Oracle Apex

1. Create a Region with position footer in 0 (global) page. And static id will  'footer'

2. Copy Pest the CSS in Source

<style>
  .footer {
   position: fixed;
   left: 0;
   bottom: 0;
   width: 100%;
   background-color: red;
   color: white;
   text-align: center;
}

3. Copy Pest the HTML in Footer Text

<div class="footer" style="border-style: outset;background-color:#efefef;color:#f5831e" >
© Developed and Maintained by ...............
<img src="Image Src" alt=".........." width="48" height="15"> </div>

Dynamic Text Logo In Oracle Apex

1. Create a Application Item. Like  AI_HEADER

2. Create a Application Process Like Below

begin
if to_number(:app_page_id)=1 then
:AI_HEADER:='Home Page';
else
:AI_HEADER:='Other Page';
end if;
end ;

3. Set  AI_HEADER into Shared Component >> User Interface >> Logo >> Custom
&AI_HEADER.

Done

Screenshot From Oracle Apex By JavaScript

Step 1 . Download the file from Here

Step 2. Upload the file into Static Application Files

Step 3. Copy-Pest the source into Page>> JavaScript>>File UTLs

Step 4. Copy-Pest the JavaScript Into Page>> Function and Global Variable Declaration

function screenshot(){
html2canvas(document.body).then(function(canvas) {
var a = document.createElement('a');
a.href = canvas.toDataURL("image/jpeg").replace("image/jpeg", "image/octet-stream");
a.download = 'image.jpg';
a.click();
}); }  

Step 5. Create a button and call dynamic action with click event and JavaScript Action and

call the function :   screenshot();

Redirect One Server App To Another Server App Without Second Time Login In Oracle Apex

1. Create Report With URL Generation                Source Server 

 SELECT   'http://URL/f?p=' 
          || '101'
          || ':'
          || 2
          || ':'
          || :APP_SESSION
          || '::::P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'
          || 'admin' -- :app_user (this user must be common between server)
          || ','
          || :APP_SESSION
          || ','
          || :AI_LOG_ID  -- This one is just for passing value
          || ','
          || :AI_BRANCH_CODE CARD_LINK,  --This one is just for passing value
          '48' CARD_TITLE,
          'Go Another Server App' CARD_TEXT
     FROM DUAL
 
2. Create A Public page with like below items               Destination Server           
     
P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'

3. Create a Process on load before header for authentication

begin
apex_authentication.login (p_username   =>:P2_USER,
                           p_password   => '123');
                                    
Exception
    when others then raise_application_error(-20001, sqlerrm);
End;

4. Create a Dynamic Action On Load with Submit event

5. Create a branch and select the page where you want to redirect.

6. Create Custom Authentication with boolean return function like below

function my_authentication (
    p_username in varchar2,
    p_password in varchar2 )
    return boolean
is
    
begin
    Return true;
exception
    when NO_DATA_FOUND then return false;
end;

Don't Forget to Copy past the function to Authentication Function Name

Universal Unique Identifier (UUID)

Using SYS_GUID()

UUID is the SYS_GUID() function provided by Oracle to produce a Globally Unique Identifier, their equivalent of a UUID.

SELECT SYS_GUID() FROM dual;

SYS_GUID()
--------------------------------
E7FBCFDD32B4B95BE0301A0A010AF268

Only Number In Oracle Apex Test Field

$(".allow-decimal").keypress(function (e) {
    if(e.which == 46){
        if($(this).val().indexOf('.') != -1) {
            return false;
        }
    }
    if (e.which != 8 && e.which != 0 && e.which != 46 && (e.which < 48 || e.which > 57)) {
        return false;
    }
});


allow-decimal

onfocusout="this.value=Number(this.value).toFixed(4)"

Remove Spinners From Oracle Apex

 To Remove Spinner From Oracle Apex Just Use This CSS.
Page Properties  ->  CSS  -> Inline

.u-Processing {
   display:none !important;
}

Get Visitor IP

Begin
    Insert Into Visitor_info (
        user_id,
        login_datetime,
        ip_address
    ) Values (
        :app_user,
        Sysdate,
        owa_util.get_cgi_env('X-FORWARDED-FOR')
    );

Exception
    When Others Then
        Null;
End;

Mask Password Using CSS

Mask Password Using CSS

#ITEM_ID { -webkit-text-security: square;}    --square
#ITEM_ID { -webkit-text-security: circle;}    --circle
#ITEM_ID { -webkit-text-security: disc;}      --disc