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; }

Interactive GRID Attributes Advanced JavaScript Initialization Code function(config) { var $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(), toolbarGroup = toolbarData.toolbarFind("actions1"); toolbarGroup.controls.unshift( { type: "SELECT", action: …