Custom Tooltip in Oracle Apex Apex items.

-- Change Field label like below

-- directly put below in field label 

-- Changed standard title tag to data-title to stop standard tooltip

<b data-title="Billing Period Name" class="lctooltip">Name</b>

-- Below code for inline css for mousehover tooltip

.lctooltip:hover:after {

    /* background: #333; */

    background: #3b83bd;

    border-radius: 5px;

    bottom: 100%;

    /* top: 50px; */

    color: #f9f9f9;

    content: attr(data-title);

    left: 100%;

    /* padding: 5px 18px; */

    padding-bottom: 2%;

    padding-top: 2%;

    /* align-content: start; */

    text-align: center;

    position: absolute;

    z-index: 98;

    width: 250%;

    border-color: black;

    opacity: 95%;

}

Running audio files from Oracle Apex

How to run background music in Oracle Apex page?


1. Add your audio file in shared component.
  Shared component --> Application files

2. Add below code to any of the static region in apex page.

<audio autoplay hidden loop> <source src="hashtag#APP_IMAGES#MyAudio.mp3" type="audio/mp3">
</audio>

View APEX_COLLECTION in SQL Developer or TOAD

Create and test APEX_COLLECTION from SQL Developer/TOAD without log in to Application

Please refer below sample code to create and test apex_collection using SQL Developer.

DECLARE
  l_security_group_id NUMBER;
  l_val               VARCHAR2(4000);
  v_arr               wwv_flow_global.vc_arr2
BEGIN
   -- Find Security Group ID
   l_security_group_id : = apex_util.find_security_group_id('&WORSPACE_NAME');
  
   -- Set Workspace ID
   apex_util.set_security_group_id(v_workspace_id);

   -- Set Application ID
   apex_application.g_flow_id  := &APP_ID;     
   
   -- Set Session ID
   apex_application.g_instance := &APP_SESSION; 

   apex_collection.create_collection('XXTEST');
   v_arr(1)  = 'Testing 1 2 3';
   apex_collection.add_members('XXTEST', p_c001 => v_arr);

   SELECT  UPPER(c001)
     INTO  l_val
     FROM  apex_collections ac
    WHERE  ac.seq_id = 1;
   
   DBMS_OUTPUT.put_line(l_val);
END;