JavaScript Function to Convert Lower Case to Upper Case

function fn_upper(pThis){
$(pThis).keyup(function(){
this.value= this.value.toUpperCase();
});
}

Show Application Manu Bar On Mobile Oracle Apex 5.1

Some times Oracle 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.

Number in Word Using Oracle Sql

select salary, to_char(to_date(salary,'j'), 'jsp') from EMPLOYEES;

Manually / Dynamically Make Text Item In Oracle Apex

DECLARE
v_column    VARCHAR2 (20);
v_value     VARCHAR2 (20);
CURSOR c_columns
IS
    SELECT Column_Name_To_Count
      FROM Table_Name
     WHERE Condition
  ORDER BY ROWNUM;

TYPE column_rec IS RECORD (column_name VARCHAR2 (30));
TYPE columns_table IS TABLE OF column_rec;
t_columns   columns_table;
BEGIN
OPEN c_columns;
FETCH c_columns
BULK COLLECT INTO t_columns;
CLOSE c_columns;
HTP.p ('<br/>');
HTP.p ('<table><tbody>');

FOR i IN 1 .. t_columns.COUNT
LOOP
  HTP.p ('<tr>');
  HTP.p (
        '<td><label for="P42_C'
     || LPAD (i, 3, 0)
     || '" id="P42_C'
     || LPAD (i, 3, 0)
     || '_LABEL">'
     || t_columns (i).column_name
     || ' :  &nbsp &nbsp  &nbsp &nbsp &nbsp  '
     || '</label></td>');
  HTP.p (
        '<td>'
     || APEX_ITEM.TEXT (1, p_item_id => 'P42_C' || LPAD (i, 3, 0))
     || '</td>');
  HTP.p ('</tr>');
END LOOP;
HTP.p ('</tbody></table>');

EXCEPTION
WHEN OTHERS
THEN
  IF c_columns%ISOPEN
  THEN
     CLOSE c_columns;
  END IF;
END;