APEX Font Toggler (AFT) Plugin. APEX Font Toggler (AFT) plugin allow users to increase or decrease application font size at their convenience and this plugin is free for use under MIT license. How to use? Steps: Download Plugin. Install this plugin into your application. Create a page region, template as blank with …

BULK Return from FORALL insert. CREATE TABLE ashish_bulk_ret ( id NUMBER GENERATED AS IDENTITY PRIMARY KEY, name VARCHAR2 (31) ); DECLARE TYPE l_rec_typ IS RECORD ( id NUMBER, name VARCHAR2 (32) ); TYPE l_ret_list_tbl_typ IS TABLE OF l_rec_typ; l_ret_list_tbl l_ret_list_tbl_typ; TYPE l_data_rec_typ IS RECORD (name …

How to find lock Object in ORACLE. SELECT a.osuser, a.sid, b.os_user_name, b.oracle_username, b.session_id, c.object_name, c.object_type FROM v$session a, v$locked_object b, dba_objects c WHERE a.sid = b.session_id AND b.object_id = c.object_id AND c.object_name = UPPER ('TABLE_NAME');

JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …

JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …

PLSQL COLLECTION PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or Varray TYPE …

PLSQL COLLECTION PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or Varray TYPE …

3 Ways to find second highest salary ORACLE SQL. Solution 1 : WITH T AS ( SELECT SAL,ENAME, DENSE_RANK() OVER (ORDER BY SAL Desc) AS Rnk FROM EMP ) SELECT SAL,ENAME FROM T WHERE Rnk IN (2); --WHERE Rnk IN (1,2,3); OR SELECT ENAME,SAL, RANK FROM( SELECT ENAME,SAL,DENSE_RANK() OVER (ORDER BY SAL DESC) RANK FROM EMP ) …

APEX_LANG APEX_LANG.MESSAGE API is great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very usefull to translate the messages or string returned from PL/SQL stored procedures, functions, triggers, packaged procedures, and functions. …

Referred from John’s cookbook sample app. Execute when Page Loads // Add the progress indicator. An alternative would be to add this to a page template. $("#t_Header .t-Header-logo").append('<div id="progress" class="progress-bar …

Interactive GRID Attributes Detail View Show - Yes For each Row <li>&ENAME. (&JOB.)</li> ENAME and JOB are GRID column Names.

Interactive GRID Static ID - emp Grid Query SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM FROM emp Function and Global Variable Declaration // create a private scope where $ is set to apex.jQuery (function($) { // This is the function that calculates over all the rows of the model and then // updates something …

Referred from John’s cookbook sample app. Inline css .gv-nested-tbl { border-collapse: collapse; width: 100%; } .gv-nested-tbl td, .gv-nested-tbl th { border: 1px solid #EAEAEA; } .a-GV-row { height: 50px; } Interactive Grid Column heading <table …

Interactive GRID Appearance CSS Classes - ig-windows-style Page Inline CSS .ig-windows-style .a-GV-table .a-GV-cell, .ig-windows-style .a-GV-table .a-GV-controlBreakHeader { border-color: transparent; } .ig-windows-style .a-GV-w-frozen .a-GV-table { border-right: none; } .ig-windows-style .a-GV-table tr.is-hover …

Interactive GRID Attributes Advanced JavaScript Initialization Code function(config) { config.reportSettingsArea = false; apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; }